{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","General Calculators","Paycheck Calc","Work Number","calculations","Self-Employment","Missing Check","Missing Check Old","Pay Rate Conversion","Day Care"],"not_rendered":{"macros":1,"external_links":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":46,"n_cols":2,"rows_kept":46}
[null,"Original calculator created by David Imeson for D2 and was last revised 12/2012.  It was then reconstructed by D16's Washington County Processing Center Lead Workers (Claudia Monterroso, Kane Ransom, and Tristan Brunscheon) in 11/2013, latest version is version 1.98 (06/11/2019)"]
[]
[null,"**If you find any issues with the Calculators, or have any suggestions on items to improve or add please e-mail Tristan.J.Brunscheon@state.or.us so we can include your suggestions in the next update.**"]
[]
[null,"District 16 Income Calculator Instructions"]
[null,"General guidelines for all calculators:\nOnly enter information into grey cells. It is fine to delete or write over information in the grey cells.\nCopy from the white cells that are surrounded by bright blue (the perimeter of these cells turn green when selected). Never delete or cut information from these cells, they should only ever be copied.\nHold down the left mouse button and drag over the cells that you want to copy, then either do ctrl+C or right click and select copy to copy that information.\nTo clear information in grey cells, select the cells and hit delete on you keyboard or right click and select clear contents.\nIf cells get corrupted, you can hit ctrl+Z repeatedly until the cells are uncorrupted, if this does not fix the problem, close the spreadsheet and reopen it.\nNever save the document, only close it without saving it, that way no cells will get corrupted on the original document. \nUse the tabs at the bottom of the spreadsheet to move between the various sheets (ie \"general calculators\", \"paycheck calc,\" \"work number,\" etc."]
[]
[null,"Date Plus and age calculations: \nThe far left field just functions like date plus but also makes it so you can enter a Participants DOB and find out their age. The lowest row in this section allows you to select plus or minus and you can enter how many days it will add or subtract from the date that you enter."]
[]
[null,"Instructions for the based on hours and rate of pay field:\nSelect whether you will be basing income on weekly or daily pay, then enter the information in the fields that appear."]
[]
[]
[]
[null,"UC and TIPS, enter the amount, copy where it says copy in the green box."]
[]
[null,"For the mortgage calculations, enter the monthly mortgage payments then the annual amount of insurance and property tax. "]
[]
[null,"Non-Cit Shelter:\nIf you are excluding a non-citizen's income, then enter rent amount paid by both included and excluded members, the number in HH, and the number of members that are being excluded."]
[]
[null,"Instructions for the based on paycheck field: \nOnly enter data in the grey fields, on the right field called based on pay checks, you put in the paycheck date and the gross check amount, then it tells you how many days are between each check, then you select the rate of pay field (which is a drop down menu) and it does the calculation and writes the narrative. You can copy and paste that part from the white fields that are surrounded by bright green. Never write or delete in the green fields."]
[]
[]
[null,"Instructions for worknumber calculator:"]
[null,"Copy the relevant weeks from the work number, past into the spread sheet (beginning in the upper left hand corner of the blue cells), select the rate of pay, and then select and copy the cells that say copy>>> in red to the left of the cell. Paste these into narrative."]
[null,"Missing check: enter the check date, amount, and YTD totals for the check preceding and following the missing check."]
[]
[null,"SEC+SEN calculator "]
[null,"Enter whether the income is monthly totals or itemized/daily amounts that need to be totaled. Select yes or no to whether or not the Participant has countable expenses associated with this work, enter the number of months that are being used in the sample, then enter the first month that this income is counted from. Next, enter the amount in the fields from left to right for each month. Lastly, copy the fields in the far right where it says copy here and paste into your narration."]
[]
[null,"For Pay Rate Converter: put in the gross income calculated under old wage received before increase, then it will convert to the new wage. Copy and paste narration. "]
[]
[null,"Day care calculations:\nThis calculation is for two parent HH, where both parents are working and you need to calculate the amount of time that day care is needed. Enter the parents names, select yes in the left most field next to the day for those days that both parents work, then enter the start and stop time for those days. Copy the information from the field that is at the very top of the sheet in bright green. You only need to copy the cells where there is a narration in those fields (starting at the bottom and moving up).  Please note this will not calculate the Child Care Hours for you, that will still need to be done manually due to policy changes in how we calculate.  This will help you narrate the schedules effectively"]
[]
[]
[]
[]
[null,"Instructions for putting document on I:\\ Drive of branch in a read only format so that it cannot be corrupted:\n\nCopy the spreadsheet from the email. Paste into the I:\\ Drive. Open the document and go to the tools drop down.\nSelect \"options,\" then go to the \"security\" tab and select \"Read-only recommended\" and then enter a password in the \"password to modify\" field. You will be prompted to enter the password a second time. Do this, then save the document (under the file drop down). Once this is done, then you can go the the sections of the I:\\ drive that you have copied the document to, right click on the document, then select create a shortcut. This shortcut can then be copied by workers and added to their desktop for quick access to the most up-to-date version that is on the I:\\ drive."]
{"$rows_empty":7}
[{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#N/A"}}]
[{"$f":"IFERROR(filename,TRUE)","v":true}]

{"sheet":"General Calculators","index":1,"n_rows":113,"n_cols":20,"rows_kept":113,"merged":[[1,1,1,3],[1,5,1,7],[1,10,1,12],[9,5,13,7],[9,10,13,12],[14,1,14,3],[16,5,16,7],[16,10,16,12],[20,1,30,1],[20,3,30,3],[25,5,30,7],[25,10,30,12]]}
[]
[null,"Date Plus and Participant Age",{"$nulls":3},"Mortgage Calculator",{"$nulls":4},"Child Support"]
[null,"Today's Date:",{"$f":"TODAY()","v":"2020-06-09"},"AGE:",{"$nulls":7}," "]
[null,"DOB:","2001-06-01",{"$f":"(C3-C4)/365","v":{"v":19.035616438356165,"d":"19.04"}},null,"Monthly Mortgage:",{"$nulls":4},"Getting/Paying:","unselected"]
[null,"Date:","2019-06-01",null,null,"Monthly HOA:",{"$nulls":3}," ","Frequency:","unselected"]
[null," ","10 Days",{"$f":"10+C$5","v":"2019-06-11"},null,"Monthly Space Rent:",{"$nulls":4},"Amount:"]
[null,null,"15 Days",{"$f":"15+C$5","v":"2019-06-16"},null,"Annual Home Insurance:",{"$nulls":4},"Verified:","unselected"]
[null,null,"30 Days",{"$f":"30+C$5","v":"2019-07-01"},null,"Annual Property Tax:",{"$nulls":5}," "," "," "]
[null,null,"45 Days",{"$f":"45+C$5","v":"2019-07-16"}]
[null,null,"60 Days",{"$f":"60+C$5","v":"2019-07-31"},null,{"$f":"IF(G6+G4+G5+G7+G8>0,S103,\"\")","v":""},{"$nulls":4},{"$f":"IF(L6>0,D70,\"\")","v":""}]
[null,null,"90 Days",{"$f":"90+C$5","v":"2019-08-30"}]
[null,null,"minus 60 Days",{"$f":"C5-60","v":"2019-04-02"}]
[null,null,"minus 120 Days",{"$f":"C5-120","v":"2019-02-01"}]
[]
[null,"Below, select plus or minus and enter # of days.",{"$nulls":3},{"$f":"IF(OR(F10<>\"\"),\"copy here>>>\",\"\")","v":""},{"$f":"F10","v":""}," ",null,null,{"$f":"IF(OR(K10<>\"\"),\"copy here>>>\",\"\")","v":""},{"$f":"K10","v":""}," "]
[null,"minus",30,{"$f":"IF(OR(B16=A94),C5+C16,IF(OR(B16=A95),C5-C16,\"\"))","v":"2019-05-02"},{"$nulls":15}," "]
[{"$nulls":5},"Non-Citizen Shelter",{"$nulls":4},"Income Based on Hours and Wage"]
[]
[null,"UC ",null,"Weekly Tips",null,"Rent Paid by NC1s:",{"$nulls":4},"Select Weekly or Daily:","unselected"]
[{"$nulls":5},"Rent paid by non-NC1s:",{"$nulls":4},{"$f":"IF(L19=D73,\"Average Hours / Day:\",\"\")","v":""}]
[null,{"$f":"IF(B20>0,A71,\"\")","v":""},null,{"$f":"IF(D20>0,C82,\"\")","v":""},null,"Number in HH:",{"$nulls":4},{"$f":"IF(L19=D73,\"Days Worked / Wk:\",\"\")","v":""}]
[{"$nulls":5},"Excluded Members:",{"$nulls":4},{"$f":"IF(L19=D72,\"Average Weekly Hrs:\",\"\")","v":""}]
[{"$nulls":5},"Prorated Allowed Cost:",{"$f":"IF(ISERROR(F100),\"\",(F100))","v":""},{"$nulls":3},{"$f":"IF(OR(L19=D73),\"Hourly Income:\",IF(OR(L19=D72),\"Hourly Income:\",\"\"))","v":""}]
[{"$nulls":10},{"$f":"IF(OR(L19=D73),\"Monthly Income:\",IF(OR(L19=D72),\"Monthly Income:\",\"\"))","v":""},{"$f":"IF(OR(L19=D72),L22*L23*4.3,IF(OR(L19=D73),L20*L21*L23*4.3,))","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":5},{"$f":"IF(ISERROR(F113),\"\",(F113))","v":""},{"$nulls":4},{"$f":"IF(L23>0,F67,\"\")","v":""}]
[null,null," ",null," "]
[]
[{"$nulls":4}," "]
[]
[]
[null,{"$f":"B21","v":""}," ",{"$f":"D21","v":""}," ",{"$f":"IF(OR(F26<>\"\"),\"copy here>>>\",\"\")","v":""},{"$f":"F26","v":""}," ",null,null,{"$f":"IF(OR(K26<>\"\"),\"copy here>>>\",\"\")","v":""},{"$f":"K26","v":""}," "]
{"$rows_empty":15}
[null,null,"weekly","wk"]
[null,null,"every other week","/biweek",{"$nulls":4},{"$f":"IF(AND(G56>0,G56<100),G56)","v":false}]
[null,null,"twice a month","/bimonth",{"$nulls":4},false]
[null,null,"monthly","/mo",{"$nulls":4},false]
[null,null,"unselected",{"$nulls":5},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},{"$f":"IF(AND(G68>0,G68<100),G68)","v":false}]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},false]
[{"$nulls":8},{"$f":"IF(AND(G72>0,G72<100),G72)","v":false}]
[{"$nulls":8},{"$f":"COUNT(I48:I65)","v":0}]
[{"$nulls":5},{"$f":"IF(OR(L19=D72),F68,IF(OR(L19=D73),F69,\"Please select daily or weekly basis of averaging pay.\"))","v":"Please select daily or weekly basis of averaging pay."},null,null,{"$f":"SUM(I48:I65)","v":0}]
[{"$f":"B20*4.3","v":0},{"$nulls":4},{"$f":"\"The participant works an average of \"&L22&\" hrs/wk. They are paid \"&DOLLAR(L23,2)&\"/hr.  Prospective Calc: \"&L22&\" hrs/wk * \"&DOLLAR(L23,2)&\"/hr * 4.3wks/mo = \"&DOLLAR(L24,2)&\"/mo.  Verified per <<INSERT SOURCE OF VERIFICATION HERE>>.\"","v":"The participant works an average of  hrs/wk. They are paid $0.00/hr.  Prospective Calc:  hrs/wk * $0.00/hr * 4.3wks/mo = $0.00/mo.  Verified per <<INSERT SOURCE OF VERIFICATION HERE>>."},null,null,{"$f":"I67/I66","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"\"The participant works an average of \"&L20&\" hrs/day and \"&L21&\" days/wk totaling \"&F70&\" hrs/wk. They are paid \"&DOLLAR(L23,2)&\" /hr. Prospective Calc:  \"&F70&\" hrs/wk *  \"&DOLLAR(L23,2)&\" /hr  = \"&DOLLAR(H76,2)&\"/wk * 4.3wks/mo =  \"&DOLLAR(L24,2)&\"/mo.  Verified per <<INSERT SOURCE OF VERIFICATION HERE>>.\"","v":"The participant works an average of  hrs/day and  days/wk totaling 0 hrs/wk. They are paid $0.00 /hr. Prospective Calc:  0 hrs/wk *  $0.00 /hr  = $0.00/wk * 4.3wks/mo =  $0.00/mo.  Verified per <<INSERT SOURCE OF VERIFICATION HERE>>."}]
[{"$nulls":3},{"$f":"IF(OR(L4=A76),\"They are receiving child support in the amount of \",IF(OR(L4=A77),\"They are paying court ordered child support in the amount of \",))&DOLLAR(L6,2)&\"\"&IF(OR(L5=C48),\"/wk * 4.3wks/mo = \"&DOLLAR(L6*4.3,2)&\"/mo.\",IF(OR(L5=C49),\"/biweek * 2.15biweeks/mo = \"&DOLLAR(L6*2.15,2)&\"/mo.\",IF(OR(L5=C50),\"/bimonth * 2bimonths/mo = \"&DOLLAR(L6*2,2)&\"/mo.\",IF(OR(L5=C51),\"/mo. \",\".\"))))&IF(L7=A81, \" Amount was verified via SMUX.\", \"\")&IF(L7=A82, \" Amount was verified by <<NARRATE SOURCE>>.\",\"\")&IF(L7=A83, \" The participant has reported this, pending for verification.\",\"\")","v":"$0.00."},null,{"$f":"L21*L20","v":0}]
[{"$f":"\"Per WAGE/ECLM participant receives UC income of \"&DOLLAR(B20,2)&\"/wk.  Prospective income calc: \"&DOLLAR(B20,2)&\"/wk *4.3wks/mo = \"&DOLLAR(A68,2)&\"/mo.\"","v":"Per WAGE/ECLM participant receives UC income of $0.00/wk.  Prospective income calc: $0.00/wk *4.3wks/mo = $0.00/mo."},null,null,"unselected"]
[{"$f":"IF(OR(B20>0),\"copy here>>>\",\"\")","v":""},null,null,"Weekly"]
[{"$nulls":3},"Daily"]
[]
["unselected"]
["receiving",{"$nulls":6},{"$f":"L20*L21*L23","v":{"v":0,"d":"$0.00"}}]
["paying"]
["smux"]
["other",null,{"$f":"D20*4.3","v":{"v":0,"d":"$0.00"}}]
["unselected"]
["SMUX"]
["Other",null,{"$f":"\"The participant states per <<SOURCE HERE>> that they receive an average of \"&DOLLAR(D20,2)&\"/wk in tips.  Prospective calc:  \"&DOLLAR(D20,2)&\"/wk * 4.3wks/mo = \"&DOLLAR(C79,2)&\"/mo.\"","v":"The participant states per <<SOURCE HERE>> that they receive an average of $0.00/wk in tips.  Prospective calc:  $0.00/wk * 4.3wks/mo = $0.00/mo."}]
["not verified."]
[{"$f":"L6*4.3","v":{"v":0,"d":"$0.00"}}]
[{"$f":"L6*2.15","v":{"v":0,"d":"$0.00"}},null,{"$f":"IF(OR(D20>0),\"copy here>>>\",\"\")","v":""}]
[{"$f":"L6*2","v":{"v":0,"d":"$0.00"}}]
{"$rows_empty":7}
["plus"]
["minus",{"$nulls":13},{"$f":"G7/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"G19/G21","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"200/4*3","v":150},{"$nulls":3},{"$f":"G8/12","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"F99+G20","v":{"$error":"#DIV/0!"}},{"$nulls":8},{"$f":"O96+O95+G4+G5+G6","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"G21-G22","v":0}]
[{"$nulls":5},{"$f":"F96*F98","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"G19/G21*(G21-G22)","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"G20+G23","v":{"$error":"#VALUE!"}}]
[]
[]
[{"$nulls":18},{"$f":"S105&S106&S107&S108&S109&S110","v":""}]
[]
[{"$nulls":5},{"$f":"\"Shelter expense is reported as \"&TEXT(G19+G20,\"$0.00\")&\"/mo. Of this expense \"&TEXT(G19,\"$0.00\")&\" is paid by members of the filing group excluded from the need group and \"&TEXT(G20,\"$0.00\")&\" is paid by members of the filing group who are included in the need group.  There are \"&G21&\" members in the filing group and \"&G22&\" members excluded from the need group (NC1s), therefore shelter expense paid by excluded members is prorated as: \"&TEXT(G19,\"$0.00\")&\"/mo / \"&G21&\" (in filing group)  * \"&G21-G22&\" (in need group) = \"&TEXT(G23,\"$0.00\")&\"/mo. \"&TEXT(G23,\"$0.00\")&\"/mo prorated + \"&TEXT(G20,\"$0.00\")&\"/mo non-prorated shelter cost = \"&TEXT(K100,\"$0.00\")&\"/mo allowed.\"","v":{"$error":"#VALUE!"}},{"$nulls":12},{"$f":"IF(G4>0,\"The participant is responsible for \"&DOLLAR(G4,2)&\"/mo from their mortgage payment.\", \"\")","v":""}]
[{"$nulls":18},{"$f":"IF(G5>0,\" Participant is responsible for \"&DOLLAR(G5,2)&\"/mo in HOA fees.\", \"\")","v":""}]
[{"$nulls":18},{"$f":"IF(G6>0,\" Participant is responsible for \"&DOLLAR(G6,2)&\"/mo in space rent.\", \"\")","v":""}]
[{"$nulls":5},{"$f":"IF((G19+G20)>0,\"Shelter expense is reported as \"&TEXT(G19+G20,\"$0.00\")&\"/mo.\", \"\")","v":""},{"$nulls":12},{"$f":"IF(G7>0,\" Participant is responsible for \"&DOLLAR(G7,2)&\"/yr from homeowner's insurance (/12mo/yr is \"&DOLLAR(O95,2)&\"/mo).\", \"\")","v":""}]
[{"$nulls":5},{"$f":"IF((G19)>0,\" Of the shelter expense \"&TEXT(G19,\"$0.00\")&\" is paid by members of the filing group excluded from the need group.\", \"\")","v":""},{"$nulls":12},{"$f":"IF(G8>0,\" Participant is responsible for \"&DOLLAR(G8,2)&\"/yr in property taxes (/12mo/yr is \"&DOLLAR(O96,2)&\"/mo).\", \"\")","v":""}]
[{"$nulls":5},{"$f":"IF((G20)>0,\" Also, of the shelter expense \"&TEXT(G20,\"$0.00\")&\" is paid by members of the filing group included from the need group.\", \"\")","v":""},{"$nulls":12},{"$f":"IF(G4+G5+G6+G7+G8>1,\" Participant's total monthly shelter responsibility is \"&DOLLAR(O97,2)&\"/mo.\",\"\")","v":""}]
[{"$nulls":5},{"$f":"\" There are \"&G21&\" members in the filing group and \"&G22&\" members excluded from the need group (NC1s).\"","v":" There are  members in the filing group and  members excluded from the need group (NC1s)."}]
[{"$nulls":5},{"$f":"\" Therefore shelter expense paid by excluded members is prorated as: \"&TEXT(G19,\"$0.00\")&\"/mo / \"&G21&\" (in filing group)  * \"&G21-G22&\" (in need group) = \"&TEXT(G23,\"$0.00\")&\"/mo. \"&TEXT(G23,\"$0.00\")&\"/mo prorated shelter cost + \"&TEXT(G20,\"$0.00\")&\"/mo non-prorated shelter cost = \"&TEXT(K100,\"$0.00\")&\"/mo allowed.\"","v":{"$error":"#VALUE!"}}]
[{"$nulls":5},{"$f":"F108&F109&F110&F111&F112","v":{"$error":"#VALUE!"}}]

{"sheet":"Paycheck Calc","index":2,"n_rows":95,"n_cols":16,"rows_kept":95,"merged":[[1,1,1,9],[3,8,4,8],[5,1,5,4],[9,1,9,2],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4]]}
[]
[null,"Paycheck Calculator"]
[]
[{"$nulls":4},"Frequency of Pay:","unselected",null,null,{"$f":"IF(F30>0,I39,\"\")","v":""}]
[{"$nulls":7}," "]
[null,{"$f":"IF(OR(F4=H51),\"Converted Income:\",IF(OR(F4=H52),\"Converted Income:\",IF(OR(F4=H53),\"Converted Income:\",IF(OR(F4=H54),\"Average Monthly Income:\",\"<<Select Frequency of Pay Above>>\"))))","v":"<<Select Frequency of Pay Above>>"},{"$nulls":3},{"$f":"IF(ISERROR(G8),\"\",(G8))","v":""}]
[{"$nulls":4},"Participant Name:"]
[{"$nulls":4},"Employer Name:",null,{"$f":"IF(OR(F4=H51),F42,IF(OR(F4=H52),F43,IF(OR(F4=H53),F44,IF(OR(F4=H54),F45,\"\"))))","v":""},{"$nulls":5},"Excluded"]
[{"$nulls":4},"Hourly Pay Rate:",null,{"$f":"IF(OR(F4=H51),G42,IF(OR(F4=H52),G43,IF(OR(F4=H53),G44,IF(OR(F4=H54),G45,\"\"))))","v":""},{"$f":"IF(F11<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"I4","v":""}," ",null,{"$f":"IF(ISERROR(F30/F32),\"\",(F30/F32))","v":""}]
[null,"Days Between Checks:",null,"DATE:","HOURS:","INCOME:",{"$f":"IF(OR(F4=H51),H42,IF(OR(F4=H52),H43,IF(OR(F4=H53),H44,IF(OR(F4=H54),H45,\"\"))))","v":""},{"$f":"IF(F11<>\"\",\"copy here >>\",\"\")","v":""},{"$nulls":5},"checks","excluded","remaining"]
[{"$nulls":7},{"$f":"IF(F11<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"IF(F11<>\"\",I77&(IF(E11<>\"\",\"  -  \"&E11&\" hrs\",\"\")),\"\")&IF(calculations!K10=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K10=FALSE,E11,0)","v":0},{"$f":"IF(calculations!$K10=FALSE,F11,0)","v":0},{"$f":"19-COUNTBLANK(F11:F29)","v":0},{"$f":"COUNTIF(calculations!K10:K28,TRUE)","v":0},{"$f":"N11-O11+O13","v":0}]
[null,{"$f":"IF(OR(A49=FALSE),\"\",A49)","v":""},{"$nulls":5},{"$f":"IF(F11<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"IF(F12<>\"\",I78&(IF(E12<>\"\",\"  -  \"&E12&\" hrs\",\"\")),IF(F11<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K11=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K11=FALSE,E12,0)","v":0},{"$f":"IF(calculations!$K11=FALSE,F12,0)","v":0}]
[null,{"$f":"IF(OR(A50=FALSE),\"\",A50)","v":""},{"$nulls":5},"",{"$f":"IF(F13<>\"\",I79&(IF(E13<>\"\",\"  -  \"&E13&\" hrs\",\"\")),IF(F12<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K12=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K12=FALSE,E13,0)","v":0},{"$f":"IF(calculations!$K12=FALSE,F13,0)","v":0},null,{"$f":"(SUMPRODUCT(--(ISNUMBER(SEARCH(\"true\",calculations!K10:K28))),--(F11:F29=\"\")))","v":0}]
[null,{"$f":"IF(OR(A51=FALSE),\"\",A51)","v":""},{"$nulls":5},"",{"$f":"IF(F14<>\"\",I80&(IF(E14<>\"\",\"  -  \"&E14&\" hrs\",\"\")),IF(F13<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K13=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K13=FALSE,E14,0)","v":0},{"$f":"IF(calculations!$K13=FALSE,F14,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F15<>\"\",I81&(IF(E15<>\"\",\"  -  \"&E15&\" hrs\",\"\")),IF(F14<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K14=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K14=FALSE,E15,0)","v":0},{"$f":"IF(calculations!$K14=FALSE,F15,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F16<>\"\",I82&(IF(E16<>\"\",\"  -  \"&E16&\" hrs\",\"\")),IF(F15<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K15=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K15=FALSE,E16,0)","v":0},{"$f":"IF(calculations!$K15=FALSE,F16,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F17<>\"\",I83&(IF(E17<>\"\",\"  -  \"&E17&\" hrs\",\"\")),IF(F16<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K16=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K16=FALSE,E17,0)","v":0},{"$f":"IF(calculations!$K16=FALSE,F17,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F18<>\"\",I84&(IF(E18<>\"\",\"  -  \"&E18&\" hrs\",\"\")),IF(F17<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K17=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K17=FALSE,E18,0)","v":0},{"$f":"IF(calculations!$K17=FALSE,F18,0)","v":0},null,{"$f":"IF(F12>0,I78&(IF(E12>0,\"  -  \"&E12&\"hrs\",\"\")),IF(F11>0,\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF(F35>0,\"  -  Avg. Hrs/Wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K11=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}]
[null,"",{"$nulls":5},"",{"$f":"IF(F19<>\"\",I85&(IF(E19<>\"\",\"  -  \"&E19&\" hrs\",\"\")),IF(F18<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K18=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K18=FALSE,E19,0)","v":0},{"$f":"IF(calculations!$K18=FALSE,F19,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F20<>\"\",I86&(IF(E20<>\"\",\"  -  \"&E20&\" hrs\",\"\")),IF(F19<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K19=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K19=FALSE,E20,0)","v":0},{"$f":"IF(calculations!$K19=FALSE,F20,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F21<>\"\",I87&(IF(E21<>\"\",\"  -  \"&E21&\" hrs\",\"\")),IF(F20<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K20=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K20=FALSE,E21,0)","v":0},{"$f":"IF(calculations!$K20=FALSE,F21,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F22<>\"\",I88&(IF(E22<>\"\",\"  -  \"&E22&\" hrs\",\"\")),IF(F21<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K21=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K21=FALSE,E22,0)","v":0},{"$f":"IF(calculations!$K21=FALSE,F22,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F23<>\"\",I89&(IF(E23<>\"\",\"  -  \"&E23&\" hrs\",\"\")),IF(F22<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K22=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K22=FALSE,E23,0)","v":0},{"$f":"IF(calculations!$K22=FALSE,F23,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F24<>\"\",I90&(IF(E24<>\"\",\"  -  \"&E24&\" hrs\",\"\")),IF(F23<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K23=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K23=FALSE,E24,0)","v":0},{"$f":"IF(calculations!$K23=FALSE,F24,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F25<>\"\",I91&(IF(E25<>\"\",\"  -  \"&E25&\" hrs\",\"\")),IF(F24<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K24=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K24=FALSE,E25,0)","v":0},{"$f":"IF(calculations!$K24=FALSE,F25,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F26<>\"\",I92&(IF(E26<>\"\",\"  -  \"&E26&\" hrs\",\"\")),IF(F25<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K25=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K25=FALSE,E26,0)","v":0},{"$f":"IF(calculations!$K25=FALSE,F26,0)","v":0}]
[null,{"$f":"IF(OR(A64=FALSE),\"\",A64)","v":""},{"$nulls":5},"",{"$f":"IF(F27<>\"\",I93&(IF(E27<>\"\",\"  -  \"&E27&\" hrs\",\"\")),IF(F26<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K26=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K26=FALSE,E27,0)","v":0},{"$f":"IF(calculations!$K26=FALSE,F27,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F28<>\"\",I94&(IF(E28<>\"\",\"  -  \"&E28&\" hrs\",\"\")),IF(F27<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K27=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K27=FALSE,E28,0)","v":0},{"$f":"IF(calculations!$K27=FALSE,F28,0)","v":0}]
[null,"",{"$nulls":5},"",{"$f":"IF(F29<>\"\",I95&(IF(E29<>\"\",\"  -  \"&E29&\" hrs\",\"\")),IF(F28<>\"\",\"Coded Income: \"&TEXT($F$6,\"####.00\")&IF($F$35<>\"n/a\",\" - *JPI/Stu* Hrs/wk: \"&TEXT($F$35,\"####.00\"),\"\"),\"\"))&IF(calculations!K28=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""},null,null,{"$f":"IF(calculations!$K28=FALSE,E29,0)","v":0},{"$f":"IF(calculations!$K28=FALSE,F29,0)","v":0}]
[{"$nulls":3},"TOTAL:",{"$f":"SUM(L11:L29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M11:M29)","v":{"v":0,"d":"$0.00"}},{"$nulls":5},{"$f":"SUM(L11:L29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M11:M29)","v":{"v":0,"d":"$0.00"}}]
[]
[{"$nulls":3},"# of Checks",null,{"$f":"IF(P11=0,\"\",P11)","v":""}]
[{"$nulls":3},"Average $ / Period:",null,{"$f":"IF(ISERROR(F30/F32),\"\",(F30/F32))","v":""}]
[{"$nulls":3},"Avg Freq of Pay",null,{"$f":"IF(ISERROR(\" \"&TEXT(A69,\"#.0\")&\" days\"),\"\",(\" \"&TEXT(A69,\"#.0\")&\" days\"))","v":""}]
[{"$nulls":3},"Weekly Hours (JPI/STU):",null,{"$f":"IFERROR(IF(G9=0,\"n/a\",(G9)),\"\")","v":""}]
[{"$nulls":3},"Weekly Hours (ABAWD-Mandatory):",null,{"$f":"IFERROR(IF(G10=0,\"n/a\",(TRUNC(G10,2))),\"\")","v":""}]
[]
[]
[{"$nulls":8},{"$f":"F7&\" is working at \"&F8&\"\"&IF(OR(F4=H51),I50,IF(OR(F4=H52),I51,IF(OR(F4=H53),I52,(IF(OR(F4=H54),I53,IF(OR(F4=H55),\"Irregular payments\",\"please select frequency of pay\"))))))","v":" is working at please select frequency of pay"}]
[]
[{"$nulls":6},"JPI/Student","ABAWD"]
[{"$nulls":3},"weekly",4.3,{"$f":"E42*F33","v":{"$error":"#VALUE!"}},{"$f":"E46/E45","v":{"$error":"#VALUE!"}},{"$f":"(E46*4)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},"biweekly",2.15,{"$f":"E43*F33","v":{"$error":"#VALUE!"}},{"$f":"E46/E44","v":{"$error":"#VALUE!"}},{"$f":"(E46*2)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},"bimonthly",2,{"$f":"E44*F33","v":{"$error":"#VALUE!"}},{"$f":"E46/E43","v":{"$error":"#VALUE!"}},{"$f":"(E46*2)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},"monthly",1,{"$f":"F33*E45","v":{"$error":"#VALUE!"}},{"$f":"E46/E42","v":{"$error":"#VALUE!"}},{"$f":"(E46)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"E30/F32","v":{"$error":"#VALUE!"}}]
[]
[]
[{"$f":"IF(AND(D50>0,D50<100),D50)","v":false},{"$nulls":6},"Unselected"]
[false,null,null,{"$f":"D12-D11","v":"00:00:00"},{"$nulls":4},{"$f":"\", and is paid weekly\"&IF(F9<>\"\",\" at \"&DOLLAR(F9,2)&\"/hr\",\"\")&\". The total counted income is \"&DOLLAR(F30,2)&\". There were a total of \"&F32&\" counted weekly payments. CALC: \"&DOLLAR(F30,2)&\" / \"&F32&\"wks = \"&DOLLAR(F33,2)&\"/wk * 4.3wks/mo = \"&DOLLAR(F42,2)&\"/mo prospective ongoing income. Used following verifications of gross income: \"","v":{"$error":"#VALUE!"}}]
[false,null,null,0,{"$nulls":3},"Weekly",{"$f":"\", and is paid biweekly\"&IF(F9<>\"\",\" at \"&DOLLAR(F9,2)&\"/hr\",\"\")&\". The total counted income is \"&DOLLAR(F30,2)&\". There were a total of \"&F32&\" counted biweekly payments. CALC:  \"&DOLLAR(F30,2)&\" / \"&F32&\" biweeks = \"&DOLLAR(F33,2)&\"/biweek * 2.15 biweeks/mo = \"&DOLLAR(F43,2)&\" /mo prospective ongoing income. Used following verifications of gross income:\"","v":{"$error":"#VALUE!"}}]
[false,null,null,0,{"$nulls":3},"Every Other Week",{"$f":"\", and is paid bimonthy\"&IF(F9<>\"\",\" at \"&DOLLAR(F9,2)&\"/hr\",\"\")&\". The total counted income is \"&DOLLAR(F30,2)&\". There were a total of \"&F32&\" counted bimonthly payments. CALC:  \"&DOLLAR(F30,2)&\" / \"&F32&\" bimonths = \"&DOLLAR(F33,2)&\"/bimonth * 2bimonths/mo = \"&DOLLAR(F44,2)&\"/mo prospective ongoing income. Used following verifications of gross income:\"","v":{"$error":"#VALUE!"}}]
[false,null,null,0,{"$nulls":3},"Twice Per Month",{"$f":"\", and is paid monthly\"&IF(F9<>\"\",\" at \"&DOLLAR(F9,2)&\"/hr\",\"\")&\". The total counted income is \"&DOLLAR(F30,2)&\". There were a total of \"&F32&\" counted monthly payments. CALC:  \"&DOLLAR(F30,2)&\"/ \"&F32&\"mo = \"&DOLLAR(F33,2)&\"/mo prospective ongoing income. Used following verifications of gross income:\"","v":{"$error":"#VALUE!"}}]
[false,null,null,0,{"$nulls":3},"Monthly"]
[false,null,null,0]
[false,null,null,0]
[false,null,null,0,{"$nulls":4},{"$f":"IF(F11>0,I77,\"\")","v":""}]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[false,null,null,0,{"$nulls":4},""]
[{"$f":"COUNT(A49:A66)","v":0},null,null,0,{"$nulls":4},""]
[{"$f":"SUM(A49:A66)","v":0},{"$nulls":7},""]
[{"$f":"A68/A67","v":{"$error":"#DIV/0!"}},{"$nulls":7},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[{"$nulls":8},{"$f":"TEXT(D11,\"mm/dd/yyy\")&\" - \"&DOLLAR(F11,2)","v":"01/00/1900 - $0.00"}]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]
[{"$nulls":8},"01/00/1900 - $0.00"]

{"sheet":"Work Number","index":3,"n_rows":249,"n_cols":41,"rows_kept":249,"merged":[[1,1,1,19],[1,29,4,29],[3,18,10,18],[7,10,7,12],[8,11,8,12],[9,11,9,12],[11,23,13,23],[15,8,15,9],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[269,23,271,23]]}
[{"$nulls":20},16,{"$nulls":8},6,12,12,12,12,12,10,4,12,56,16]
[null,"Work Number Calculator",{"$nulls":27},{"$f":"IF(OR(J14=\"\",N4=\"unselected\"),\"\",\"The following information is from Work#'s 'Income Summary' for \"&J14&\" and is current as of \"&TEXT(TODAY(),(\"mm/dd/yyyy\"))&\":  Base Salary: $\"&K14&\", Overtime: $\"&L14&\", Commissions: $\"&M14&\", Bonus: $\"&N14&\", Other: $\"&O14&\", Total: $\"&P14&\".\")","v":""}]
[{"$nulls":3},"Paste Income Summery Info Below (Yellow):",null,null,"Paste Paydate Info Below (Yellow):",{"$nulls":16},"Paste Income Summery Info Below (Yellow):"]
[null,null,"Year:",{"$f":"IF(X4=\"\",\"\",X4)","v":""},null,"(1) Period End Date:",{"$f":"IF(X15=\"\",\"\",X15)","v":""},{"$nulls":5},"Frequency of Pay:  ","Unselected",{"$nulls":4},{"$f":"IF(N36=0,\"\",AD46&\"\n\n \"&AD2)","v":""}," ",null,null,"Year:"]
[null,null,"Base Salary:",{"$f":"IF(X5=\"\",\"\",X5)","v":""},null,"(1) Pay Date:","",{"$nulls":12}," ",null,null,"Base Salary:"]
[null,null,"Overtime:","",null,"(1) Hours Worked:","",{"$nulls":7},{"$f":"IF(OR(N4=AB55),AD63,IF(OR(N4=AB56),AD64,IF(OR(N4=AB57),AD65,IF(OR(N4=AB58),AD66,0))))","v":0},{"$nulls":4}," ",null,null,"Overtime:"]
[null,null,"Commissions:","",null,"(1) Gross Earnings:","",{"$nulls":7},{"$f":"IF(OR(N4=AB55),AE63,IF(OR(N4=AB56),AE64,IF(OR(N4=AB57),AE65,IF(OR(N4=AB58),AE66,0))))","v":0},{"$nulls":4}," ",null,null,"Commissions:",{"$nulls":17},"Unselected"]
[null,null,"Bonus:","",null,"(1) Net Earnings:","",{"$nulls":3},{"$f":"IF(OR(N4=AB55),\"Converted Income:  \",IF(OR(N4=AB56),\"Converted Income:  \",IF(OR(N4=AB57),\"Converted Income:  \",IF(OR(N4=AB58),\"Average Monthly Income:\",\"<<Select Frequency of Pay Above>>\"))))","v":"<<Select Frequency of Pay Above>>"},null,null,{"$f":"IF(ISERROR(O6),\"\",(O6))","v":{"v":0,"d":"$0.00"}},{"$f":"IF(OR(N4=AB55),AF63,IF(OR(N4=AB56),AF64,IF(OR(N4=AB57),AF65,IF(OR(N4=AB58),AF66,0))))","v":0},{"$nulls":4}," ",null,null,"Bonus:"]
[null,null,"Other:","",null,"(2) Period End Date:","",{"$nulls":4},"Participant Name:  ",{"$nulls":10},"Other:",{"$nulls":17},"Weekly"]
[null,null,"Total:","",null,"(2) Pay Date:","",{"$nulls":4},"Employer Name:  ",{"$nulls":10},"Total:",{"$nulls":17},"Every Other Week"]
[{"$nulls":5},"(2) Hours Worked:","",{"$nulls":12}," ",{"$nulls":11},"checks","excluded","remaining",{"$nulls":6},"Twice Per Month"]
[{"$nulls":5},"(2) Gross Earnings:","",{"$nulls":16},"Paste Paydate Info Below (Yellow):",{"$nulls":16},"Monthly"]
[{"$nulls":5},"(2) Net Earnings:","",null,null,"Year","Base Salary:","Overtime:","Commissions:","Bonus:","Other:","Total:",null,{"$f":"IF(S13<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"IF(N36=0,\"\",AD46)","v":""}," "]
[{"$nulls":5},"(3) Period End Date:","",null,"Income Summary:",{"$f":"IF($D$4=\"\",\"\",$D$4)","v":""},{"$f":"IF($D$5=\"\",\"\",$D$5)","v":""},{"$f":"IF($D$6=\"\",\"\",$D$6)","v":""},{"$f":"IF($D$7=\"\",\"\",$D$7)","v":""},{"$f":"IF($D$8=\"\",\"\",$D$8)","v":""},{"$f":"IF($D$9=\"\",\"\",$D$9)","v":""},{"$f":"IF($D$10=\"\",\"\",$D$10)","v":""},null,{"$f":"IF(S13<>\"\",\"copy here >>\",\"\")","v":""},null," "]
[{"$nulls":5},"(3) Pay Date:","",{"$nulls":10},{"$f":"IF(S13<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"IF(N36=0,\"\",AD2)","v":""}," ",null,null,"(1) Period End Date:",{"$nulls":6},{"$f":"IF(calculations!L10=FALSE,M17,0)","v":""},{"$f":"IF(calculations!L10=FALSE,N17,0)","v":""},{"$f":"19-COUNTBLANK(N17:N35)","v":0},{"$f":"COUNTIF(calculations!L10:L28,TRUE)","v":0},{"$f":"AF15-AG15+AG17","v":0}]
[{"$nulls":5},"(3) Hours Worked:","",null,"Days Between Paydates:",null,"Period End Date:","Pay Date:","Hours Worked:","Gross Income:","Net Income:",null,null,{"$f":"IF(S13<>\"\",\"copy here >>\",\"\")","v":""},null," ",null,null,"(1) Pay Date:",{"$nulls":6},{"$f":"IF(calculations!L11=FALSE,M18,0)","v":""},{"$f":"IF(calculations!L11=FALSE,N18,0)","v":""}]
[{"$nulls":5},"(3) Gross Earnings:","",{"$nulls":3},{"$f":"IF($G$4=\"\",\"\",$G$4)","v":""},{"$f":"IF($G$5=\"\",\"\",$G$5)","v":""},{"$f":"IF($G$6=\"\",\"\",$G$6)","v":""},{"$f":"IF($G$7=\"\",\"\",$G$7)","v":""},{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,{"$f":"IF(S17<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"IF($N$17<>\"\",$S$73&IF($M$17<>\"\",\" - \"&$M$17&\" hrs\",\"\"),\"\")&IF(calculations!$L$10=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(1) Hours Worked:",{"$nulls":6},{"$f":"IF(calculations!L12=FALSE,M19,0)","v":""},{"$f":"IF(calculations!L12=FALSE,N19,0)","v":""},null,{"$f":"(SUMPRODUCT(--(ISNUMBER(SEARCH(\"true\",calculations!L10:L28))),--(N17:N35=\"\")))","v":0}]
[{"$nulls":5},"(3) Net Earnings:","",null,null,{"$f":"IF(L18=\"\",\"\",ABS(L18-L17))","v":""},{"$f":"IF($G$9=\"\",\"\",$G$9)","v":""},{"$f":"IF($G$10=\"\",\"\",$G$10)","v":""},{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""},{"$f":"IF($G$12=\"\",\"\",$G$12)","v":""},{"$f":"IF($G$13=\"\",\"\",$G$13)","v":""},null,null,"",{"$f":"IF(N18<>\"\",S74&IF(M18<>\"\",\" - \"&M18&\" hrs\",\"\"),IF(N17<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L11=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(1) Gross Earnings:",{"$nulls":6},{"$f":"IF(calculations!L13=FALSE,M20,0)","v":""},{"$f":"IF(calculations!L13=FALSE,N20,0)","v":""}]
[{"$nulls":5},"(4) Period End Date:","",null,null,"",{"$f":"IF($G$14=\"\",\"\",$G$14)","v":""},{"$f":"IF($G$15=\"\",\"\",$G$15)","v":""},{"$f":"IF($G$16=\"\",\"\",$G$16)","v":""},{"$f":"IF($G$17=\"\",\"\",$G$17)","v":""},{"$f":"IF($G$18=\"\",\"\",$G$18)","v":""},null,null,"",{"$f":"IF(N19<>\"\",S75&IF(M19<>\"\",\" - \"&M19&\" hrs\",\"\"),IF(N18<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L12=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(1) Net Earnings:",{"$nulls":6},{"$f":"IF(calculations!L14=FALSE,M21,0)","v":""},{"$f":"IF(calculations!L14=FALSE,N21,0)","v":""}]
[{"$nulls":5},"(4) Pay Date:","",null,null,"",{"$f":"IF($G$19=\"\",\"\",$G$19)","v":""},{"$f":"IF($G$20=\"\",\"\",$G$20)","v":""},{"$f":"IF($G$21=\"\",\"\",$G$21)","v":""},{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},{"$f":"IF($G$23=\"\",\"\",$G$23)","v":""},null,null,"",{"$f":"IF(N20<>\"\",S76&IF(M20<>\"\",\" - \"&M20&\" hrs\",\"\"),IF(N19<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L13=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(2) Period End Date:",{"$nulls":6},{"$f":"IF(calculations!L15=FALSE,M22,0)","v":""},{"$f":"IF(calculations!L15=FALSE,N22,0)","v":""}]
[{"$nulls":5},"(4) Hours Worked:","",null,null,"",{"$f":"IF($G$24=\"\",\"\",$G$24)","v":""},{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},{"$f":"IF($G$26=\"\",\"\",$G$26)","v":""},{"$f":"IF($G$27=\"\",\"\",$G$27)","v":""},{"$f":"IF($G$28=\"\",\"\",$G$28)","v":""},null,null,"",{"$f":"IF(N21<>\"\",S77&IF(M21<>\"\",\" - \"&M21&\" hrs\",\"\"),IF(N20<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L14=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(2) Pay Date:",{"$nulls":6},{"$f":"IF(calculations!L16=FALSE,M23,0)","v":""},{"$f":"IF(calculations!L16=FALSE,N23,0)","v":""}]
[{"$nulls":5},"(4) Gross Earnings:","",null,null,"",{"$f":"IF($G$29=\"\",\"\",$G$4)","v":""},{"$f":"IF($G$30=\"\",\"\",$G$30)","v":""},{"$f":"IF($G$31=\"\",\"\",$G$31)","v":""},{"$f":"IF($G$32=\"\",\"\",$G$32)","v":""},{"$f":"IF($G$33=\"\",\"\",$G$33)","v":""},null,null,"",{"$f":"IF(N22<>\"\",S78&IF(M22<>\"\",\" - \"&M22&\" hrs\",\"\"),IF(N21<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L15=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(2) Hours Worked:",{"$nulls":6},{"$f":"IF(calculations!L17=FALSE,M24,0)","v":""},{"$f":"IF(calculations!L17=FALSE,N24,0)","v":""}]
[{"$nulls":5},"(4) Net Earnings:","",null,null,"",{"$f":"IF($G$34=\"\",\"\",$G$34)","v":""},{"$f":"IF($G$35=\"\",\"\",$G$35)","v":""},{"$f":"IF($G$36=\"\",\"\",$G$36)","v":""},{"$f":"IF($G$37=\"\",\"\",$G$37)","v":""},{"$f":"IF($G$38=\"\",\"\",$G$38)","v":""},null,null,"",{"$f":"IF(N23<>\"\",S79&IF(M23<>\"\",\" - \"&M23&\" hrs\",\"\"),IF(N22<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L16=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(2) Gross Earnings:",{"$nulls":6},{"$f":"IF(calculations!L18=FALSE,M25,0)","v":""},{"$f":"IF(calculations!L18=FALSE,N25,0)","v":""}]
[{"$nulls":5},"(5) Period End Date:","",null,null,"",{"$f":"IF($G$39=\"\",\"\",$G$39)","v":""},{"$f":"IF($G$40=\"\",\"\",$G$40)","v":""},{"$f":"IF($G$41=\"\",\"\",$G$41)","v":""},{"$f":"IF($G$42=\"\",\"\",$G$42)","v":""},{"$f":"IF($G$43=\"\",\"\",$G$43)","v":""},null,null,"",{"$f":"IF(N24<>\"\",S80&IF(M24<>\"\",\" - \"&M24&\" hrs\",\"\"),IF(N23<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L17=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(2) Net Earnings:",{"$nulls":6},{"$f":"IF(calculations!L19=FALSE,M26,0)","v":""},{"$f":"IF(calculations!L19=FALSE,N26,0)","v":""}]
[{"$nulls":5},"(5) Pay Date:","",null,null,"",{"$f":"IF($G$44=\"\",\"\",$G$44)","v":""},{"$f":"IF($G$45=\"\",\"\",$G$45)","v":""},{"$f":"IF($G$46=\"\",\"\",$G$46)","v":""},{"$f":"IF($G$47=\"\",\"\",$G$47)","v":""},{"$f":"IF($G$48=\"\",\"\",$G$48)","v":""},null,null,"",{"$f":"IF(N25<>\"\",S81&IF(M25<>\"\",\" - \"&M25&\" hrs\",\"\"),IF(N24<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L18=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(3) Period End Date:",{"$nulls":6},{"$f":"IF(calculations!L20=FALSE,M27,0)","v":""},{"$f":"IF(calculations!L20=FALSE,N27,0)","v":""}]
[{"$nulls":5},"(5) Hours Worked:","",null,null,"",{"$f":"IF($G$49=\"\",\"\",$G$49)","v":""},{"$f":"IF($G$50=\"\",\"\",$G$50)","v":""},{"$f":"IF($G$51=\"\",\"\",$G$51)","v":""},{"$f":"IF($G$52=\"\",\"\",$G$52)","v":""},{"$f":"IF($G$53=\"\",\"\",$G$53)","v":""},null,null,"",{"$f":"IF(N26<>\"\",S82&IF(M26<>\"\",\" - \"&M26&\" hrs\",\"\"),IF(N25<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L19=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(3) Pay Date:",{"$nulls":6},{"$f":"IF(calculations!L21=FALSE,M28,0)","v":""},{"$f":"IF(calculations!L21=FALSE,N28,0)","v":""}]
[{"$nulls":5},"(5) Gross Earnings:","",null,null,"",{"$f":"IF($G$54=\"\",\"\",$G$54)","v":""},{"$f":"IF($G$55=\"\",\"\",$G$55)","v":""},{"$f":"IF($G$56=\"\",\"\",$G$56)","v":""},{"$f":"IF($G$57=\"\",\"\",$G$57)","v":""},{"$f":"IF($G$58=\"\",\"\",$G$58)","v":""},null,null,"",{"$f":"IF(N27<>\"\",S83&IF(M27<>\"\",\" - \"&M27&\" hrs\",\"\"),IF(N26<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L20=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(3) Hours Worked:",{"$nulls":6},{"$f":"IF(calculations!L22=FALSE,M29,0)","v":""},{"$f":"IF(calculations!L22=FALSE,N29,0)","v":""}]
[{"$nulls":5},"(5) Net Earnings:","",null,null,"",{"$f":"IF($G$59=\"\",\"\",$G$59)","v":""},{"$f":"IF($G$60=\"\",\"\",$G$60)","v":""},{"$f":"IF($G$61=\"\",\"\",$G$61)","v":""},{"$f":"IF($G$62=\"\",\"\",$G$62)","v":""},{"$f":"IF($G$63=\"\",\"\",$G$63)","v":""},null,null,"",{"$f":"IF(N28<>\"\",S84&IF(M28<>\"\",\" - \"&M28&\" hrs\",\"\"),IF(N27<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L21=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(3) Gross Earnings:",{"$nulls":6},{"$f":"IF(calculations!L23=FALSE,M30,0)","v":""},{"$f":"IF(calculations!L23=FALSE,N30,0)","v":""}]
[{"$nulls":5},"(6) Period End Date:","",null,null,"",{"$f":"IF($G$64=\"\",\"\",$G$64)","v":""},{"$f":"IF($G$65=\"\",\"\",$G$65)","v":""},{"$f":"IF($G$66=\"\",\"\",$G$66)","v":""},{"$f":"IF($G$67=\"\",\"\",$G$67)","v":""},{"$f":"IF($G$68=\"\",\"\",$G$68)","v":""},null,null,"",{"$f":"IF(N29<>\"\",S85&IF(M29<>\"\",\" - \"&M29&\" hrs\",\"\"),IF(N28<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L22=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(3) Net Earnings:",{"$nulls":6},{"$f":"IF(calculations!L24=FALSE,M31,0)","v":""},{"$f":"IF(calculations!L24=FALSE,N31,0)","v":""}]
[{"$nulls":5},"(6) Pay Date:","",null,null,"",{"$f":"IF($G$69=\"\",\"\",$G$69)","v":""},{"$f":"IF($G$70=\"\",\"\",$G$70)","v":""},{"$f":"IF($G$71=\"\",\"\",$G$71)","v":""},{"$f":"IF($G$72=\"\",\"\",$G$72)","v":""},{"$f":"IF($G$73=\"\",\"\",$G$73)","v":""},null,null,"",{"$f":"IF(N30<>\"\",S86&IF(M30<>\"\",\" - \"&M30&\" hrs\",\"\"),IF(N29<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L23=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(4) Period End Date:",{"$nulls":6},{"$f":"IF(calculations!L25=FALSE,M32,0)","v":""},{"$f":"IF(calculations!L25=FALSE,N32,0)","v":""}]
[{"$nulls":5},"(6) Hours Worked:","",null,null,"",{"$f":"IF($G$74=\"\",\"\",$G$74)","v":""},{"$f":"IF($G$75=\"\",\"\",$G$75)","v":""},{"$f":"IF($G$76=\"\",\"\",$G$76)","v":""},{"$f":"IF($G$77=\"\",\"\",$G$77)","v":""},{"$f":"IF($G$78=\"\",\"\",$G$78)","v":""},null,null,"",{"$f":"IF(N31<>\"\",S87&IF(M31<>\"\",\" - \"&M31&\" hrs\",\"\"),IF(N30<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L24=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(4) Pay Date:",{"$nulls":6},{"$f":"IF(calculations!L26=FALSE,M33,0)","v":""},{"$f":"IF(calculations!L26=FALSE,N33,0)","v":""}]
[{"$nulls":5},"(6) Gross Earnings:","",null,null,"",{"$f":"IF($G$79=\"\",\"\",$G$79)","v":""},{"$f":"IF($G$80=\"\",\"\",$G$80)","v":""},{"$f":"IF($G$81=\"\",\"\",$G$81)","v":""},{"$f":"IF($G$82=\"\",\"\",$G$82)","v":""},{"$f":"IF($G$83=\"\",\"\",$G$83)","v":""},null,null,"",{"$f":"IF(N32<>\"\",S88&IF(M32<>\"\",\" - \"&M32&\" hrs\",\"\"),IF(N31<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L25=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(4) Hours Worked:",{"$nulls":6},{"$f":"IF(calculations!L27=FALSE,M34,0)","v":""},{"$f":"IF(calculations!L27=FALSE,N34,0)","v":""}]
[{"$nulls":5},"(6) Net Earnings:","",null,null,"",{"$f":"IF($G$84=\"\",\"\",$G$84)","v":""},{"$f":"IF($G$85=\"\",\"\",$G$85)","v":""},{"$f":"IF($G$86=\"\",\"\",$G$86)","v":""},{"$f":"IF($G$87=\"\",\"\",$G$87)","v":""},{"$f":"IF($G$88=\"\",\"\",$G$88)","v":""},null,null,"",{"$f":"IF(N33<>\"\",S89&IF(M33<>\"\",\" - \"&M33&\" hrs\",\"\"),IF(N32<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L26=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," "," ",null,"(4) Gross Earnings:",{"$nulls":6},{"$f":"IF(calculations!L28=FALSE,M35,0)","v":""},{"$f":"IF(calculations!L28=FALSE,N35,0)","v":""}]
[{"$nulls":5},"(7) Period End Date:","",null,null,"",{"$f":"IF($G$89=\"\",\"\",$G$89)","v":""},{"$f":"IF($G$90=\"\",\"\",$G$90)","v":""},{"$f":"IF($G$91=\"\",\"\",$G$91)","v":""},{"$f":"IF($G$92=\"\",\"\",$G$92)","v":""},{"$f":"IF($G$93=\"\",\"\",$G$93)","v":""},null,null,"",{"$f":"IF(N34<>\"\",S90&IF(M34<>\"\",\" - \"&M34&\" hrs\",\"\"),IF(N33<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L27=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(4) Net Earnings:"]
[{"$nulls":5},"(7) Pay Date:","",null,null,"",{"$f":"IF($G$94=\"\",\"\",$G$94)","v":""},{"$f":"IF($G$95=\"\",\"\",$G$95)","v":""},{"$f":"IF($G$96=\"\",\"\",$G$96)","v":""},{"$f":"IF($G$97=\"\",\"\",$G$97)","v":""},{"$f":"IF($G$98=\"\",\"\",$G$98)","v":""},null,null,"",{"$f":"IF(N35<>\"\",S91&IF(M35<>\"\",\" - \"&M35&\" hrs\",\"\"),IF(N34<>\"\",\"Coded Income: \"&TEXT($N$8,\"####.00\")&IF(N42<>\"\",\" - *JPI/Stu* Hrs/wk: \"&TEXT(N42,\"####.00\"),\"\"),\"\"))&IF(calculations!L28=TRUE,\",  Excluded as <<insert reason here>>\",\"\")","v":""}," ",null,null,"(5) Period End Date:"]
[{"$nulls":5},"(7) Hours Worked:",{"$f":"IF(X47=\"\",\"\",X47)","v":""},{"$nulls":5},"Total $:",{"$f":"SUM(AE15:AE33)","v":{"v":0,"d":"$0.00"}},{"$nulls":8},"(5) Pay Date:"]
[{"$nulls":5},"(7) Gross Earnings:","",{"$nulls":5},"Total Hours:",{"$f":"SUM(AD15:AD33)","v":{"v":0,"d":"0.00"}},{"$nulls":8},"(5) Hours Worked:"]
[{"$nulls":5},"(7) Net Earnings:","",{"$nulls":15},"(5) Gross Earnings:"]
[{"$nulls":5},"(8) Period End Date:","",{"$nulls":4},"# of Checks:",null,{"$f":"IF(AH15=0,\"\",AH15)","v":""},{"$nulls":8},"(5) Net Earnings:"]
[{"$nulls":5},"(8) Pay Date:","",{"$nulls":4},"Average $ / Period:",null,{"$f":"IF(ISERROR(N36/N39),\"\",(N36/N39))","v":""},{"$nulls":8},"(6) Period End Date:"]
[{"$nulls":5},"(8) Hours Worked:","",{"$nulls":4},"Avg Freq of Pay:",null,{"$f":"IF(ISERROR(\" \"&TEXT(B53,\"#.0\")&\" days\"),\"\",(\" \"&TEXT(B53,\"#.0\")&\" days\"))","v":""},{"$nulls":8},"(6) Pay Date:"]
[{"$nulls":5},"(8) Gross Earnings:","",{"$nulls":4},"Weekly Hours (JPI/STU):",null,{"$f":"IFERROR(IF(O7=0,\"\",TRUNC(O7,2)),\"\")","v":""},{"$nulls":8},"(6) Hours Worked:"]
[{"$nulls":5},"(8) Net Earnings:","",{"$nulls":15},"(6) Gross Earnings:"]
[{"$nulls":4}," ","(9) Period End Date:","",{"$nulls":15},"(6) Net Earnings:"]
[{"$nulls":4}," ","(9) Pay Date:","",{"$nulls":15},"(7) Period End Date:"]
[{"$nulls":4}," ","(9) Hours Worked:","",{"$nulls":15},"(7) Pay Date:",{"$nulls":6},{"$f":"N9&\" is working at \"&N10&\"\"&IF(OR(N4=AB55),AD53,IF(OR(N4=AB56),AD54,IF(OR(N4=AB57),AD55,(IF(OR(N4=AB58),AD56,IF(OR(N4=AB59),\"Irregular payments\",\" please select frequency of pay\"))))))","v":" is working at  please select frequency of pay"}]
[{"$nulls":4}," ","(9) Gross Earnings:","",{"$nulls":15},"(7) Hours Worked:"]
[{"$nulls":4}," ","(9) Net Earnings:","",{"$nulls":15},"(7) Gross Earnings:"]
[{"$nulls":4}," ","(10) Period End Date:","",{"$nulls":15},"(7) Net Earnings:"]
[{"$nulls":4}," ","(10) Pay Date:","",{"$nulls":15},"(8) Period End Date:"]
[null,{"$f":"COUNT(J17:J35)","v":{"v":0,"d":"0.00"}},null,null," ","(10) Hours Worked:","",{"$nulls":15},"(8) Pay Date:"]
[null,{"$f":"SUM(J17:J35)","v":0},null,null," ","(10) Gross Earnings:","",{"$nulls":15},"(8) Hours Worked:"]
[null,{"$f":"B52/B51","v":{"$error":"#DIV/0!"}},null,null," ","(10) Net Earnings:","",{"$nulls":11},{"$f":"IF(N17>0,S73,\"\")","v":{"$error":"#VALUE!"}},{"$nulls":3},"(8) Gross Earnings:",{"$nulls":6},{"$f":"\", and is paid weekly. The total counted income is \"&DOLLAR(N36,2)&\". There were a total of \"&N39&\" counted weekly payments. CALC: \"&DOLLAR(N36,2)&\" / \"&N39&\"wks = \"&DOLLAR(N40,2)&\"/wk * 4.3wks/mo = \"&DOLLAR(N8,2)&\"/mo prospective ongoing income. Used following verifications of gross income per Work#: \"","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(11) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(8) Net Earnings:",{"$nulls":6},{"$f":"\", and is paid biweekly. The total counted income is \"&DOLLAR(N36,2)&\". There were a total of \"&N39&\" counted biweekly payments. CALC: \"&DOLLAR(N36,2)&\" / \"&N39&\"biweeks = \"&DOLLAR(N40,2)&\"/biweek * 2.15biweeks/mo = \"&DOLLAR(N8,2)&\"/mo prospective ongoing income. Used following verifications of gross income per Work#: \"","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(11) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(9) Period End Date:",{"$nulls":4},"Weekly",null,{"$f":"\", and is paid bimonthly. The total counted income is \"&DOLLAR(N36,2)&\". There were a total of \"&N39&\" counted bimonthly payments. CALC: \"&DOLLAR(N36,2)&\" / \"&N39&\"bimonths = \"&DOLLAR(N40,2)&\"/bimonth * 2bimonths/mo = \"&DOLLAR(N8,2)&\"/mo prospective ongoing income. Used following verifications of gross income per Work#: \"","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(11) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(9) Pay Date:",{"$nulls":4},"Every Other Week",null,{"$f":"\", and is paid monthly. The total counted income is \"&DOLLAR(N36,2)&\". There were a total of \"&N39&\" counted monthly payments. CALC:  \"&DOLLAR(N36,2)&\"/ \"&N39&\"mo = \"&DOLLAR(N40,2)&\"/mo prospective ongoing income. Used following verifications of gross income per Work#:\"","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(11) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(9) Hours Worked:",{"$nulls":4},"Twice Per Month"]
[{"$nulls":4}," ","(11) Net Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(9) Gross Earnings:",{"$nulls":4},"Monthly",{"$nulls":3},{"$f":"\", and is paid weekly. The total counted income is \"&DOLLAR(N36,2)&\". There were a total of \"&N39&\" weekly payments. CALC: \"&DOLLAR(N36,2)&\" / \"&N39&\"wks = \"&DOLLAR(N40,2)&\"/wk * 4.3wks/mo = \"&DOLLAR(N8,2)&\"/mo prospective ongoing income. Used following verifications of gross income per Work#: \"","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(12) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(9) Net Earnings:",{"$nulls":6},{"$f":"IF(OR(N4=AB55),AD53,IF(OR(N4=AB56),AD54,IF(OR(N4=AB57),AD55,(IF(OR(N4=AB58),AD56,IF(OR(N4=AB59),\"Irregular payments\",\"please select frequency of pay\"))))))","v":"please select frequency of pay"}]
[{"$nulls":4}," ","(12) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(10) Period End Date:",{"$nulls":4},"Unselected"]
[{"$nulls":4}," ","(12) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(10) Pay Date:"]
[{"$nulls":4}," ","(12) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(10) Hours Worked:",{"$nulls":8},{"$f":"N37/N39","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(12) Net Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(10) Gross Earnings:",{"$nulls":6},{"$f":"AB64*N40","v":{"$error":"#VALUE!"}},{"$f":"AB67*$AB$68","v":{"$error":"#VALUE!"}},{"$f":"(AB68*4.3)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(13) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(10) Net Earnings:",{"$nulls":4},4.3,null,{"$f":"AB65*N40","v":{"$error":"#VALUE!"}},{"$f":"$AB$68/AB66","v":{"$error":"#VALUE!"}},{"$f":"(AB68*2.15)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(13) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(11) Period End Date:",{"$nulls":4},2.15,null,{"$f":"AB66*N40","v":{"$error":"#VALUE!"}},{"$f":"$AB$68/AB65","v":{"$error":"#VALUE!"}},{"$f":"(AB68*2)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(13) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(11) Pay Date:",{"$nulls":4},2,null,{"$f":"N40","v":""},{"$f":"AB68/4.3","v":{"$error":"#VALUE!"}},{"$f":"(AB68)/4","v":{"$error":"#VALUE!"}}]
[{"$nulls":4}," ","(13) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(11) Hours Worked:",{"$nulls":4},1]
[{"$nulls":4}," ","(13) Net Earnings:",{"$f":"IF(X79=\"\",\"\",X79)","v":""},{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(11) Gross Earnings:",{"$nulls":4},{"$f":"IF(ISERROR(N37/N39),\"\",(N37/N39))","v":""}]
[{"$nulls":4}," ","(14) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(11) Net Earnings:"]
[{"$nulls":4}," ","(14) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(12) Period End Date:"]
[{"$nulls":4}," ","(14) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(12) Pay Date:"]
[{"$nulls":4}," ","(14) Gross Earnings:","",{"$nulls":15},"(12) Hours Worked:"]
[{"$nulls":4}," ","(14) Net Earnings:","",{"$nulls":11},{"$f":"TEXT(L17,\"mm/dd/yyy\")&\" - \"&DOLLAR(N17,2)","v":{"$error":"#VALUE!"}},{"$nulls":3},"(12) Gross Earnings:"]
[{"$nulls":4}," ","(15) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(12) Net Earnings:"]
[{"$nulls":4}," ","(15) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(13) Period End Date:"]
[{"$nulls":4}," ","(15) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(13) Pay Date:"]
[{"$nulls":4}," ","(15) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(13) Hours Worked:"]
[{"$nulls":4}," ","(15) Net Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(13) Gross Earnings:"]
[{"$nulls":4}," ","(16) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(13) Net Earnings:"]
[{"$nulls":4}," ","(16) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(14) Period End Date:"]
[{"$nulls":4}," ","(16) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(14) Pay Date:"]
[{"$nulls":4}," ","(16) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(14) Hours Worked:"]
[{"$nulls":4}," ","(16) Net Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(14) Gross Earnings:"]
[{"$nulls":4}," ","(17) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(14) Net Earnings:"]
[{"$nulls":4}," ","(17) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(15) Period End Date:"]
[{"$nulls":4}," ","(17) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(15) Pay Date:"]
[{"$nulls":4}," ","(17) Gross Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(15) Hours Worked:"]
[{"$nulls":4}," ","(17) Net Earnings:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(15) Gross Earnings:"]
[{"$nulls":4}," ","(18) Period End Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(15) Net Earnings:"]
[{"$nulls":4}," ","(18) Pay Date:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(16) Period End Date:"]
[{"$nulls":4}," ","(18) Hours Worked:","",{"$nulls":11},{"$error":"#VALUE!"},{"$nulls":3},"(16) Pay Date:"]
[{"$nulls":4}," ","(18) Gross Earnings:","",{"$nulls":15},"(16) Hours Worked:"]
[{"$nulls":4}," ","(18) Net Earnings:","",{"$nulls":15},"(16) Gross Earnings:"]
[{"$nulls":4}," ","(19) Period End Date:","",{"$nulls":15},"(16) Net Earnings:"]
[{"$nulls":4}," ","(19) Pay Date:","",{"$nulls":15},"(17) Period End Date:"]
[{"$nulls":4}," ","(19) Hours Worked:","",{"$nulls":15},"(17) Pay Date:"]
[{"$nulls":4}," ","(19) Gross Earnings:","",{"$nulls":15},"(17) Hours Worked:"]
[{"$nulls":4}," ","(19) Net Earnings:","",{"$nulls":15},"(17) Gross Earnings:"]
[{"$nulls":22},"(17) Net Earnings:"]
[{"$nulls":22},"(18) Period End Date:"]
[{"$nulls":22},"(18) Pay Date:"]
[{"$nulls":22},"(18) Hours Worked:"]
[{"$nulls":22},"(18) Gross Earnings:"]
[{"$nulls":22},"(18) Net Earnings:"]
[{"$nulls":22},"(19) Period End Date:"]
[{"$nulls":22},"(19) Pay Date:"]
[{"$nulls":22},"(19) Hours Worked:"]
[{"$nulls":22},"(19) Gross Earnings:"]
[{"$nulls":22},"(19) Net Earnings:"]
{"$rows_empty":112}
[{"$nulls":20},{"$f":"IF($G$4=\"\",\"\",$G$4)","v":""},{"$f":"IF($G$5=\"\",\"\",$G$5)","v":""},{"$f":"IF($G$6=\"\",\"\",$G$6)","v":""},{"$f":"IF($G$7=\"\",\"\",$G$7)","v":""},{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""}]
[{"$nulls":20},{"$f":"IF($G$9=\"\",\"\",$G$9)","v":""},{"$f":"IF($G$10=\"\",\"\",$G$10)","v":""},{"$f":"IF($G$11=\"\",\"\",$G$11)","v":""},{"$f":"IF($G$12=\"\",\"\",$G$12)","v":""},{"$f":"IF($G$13=\"\",\"\",$G$13)","v":""}]
[{"$nulls":20},{"$f":"IF($G$14=\"\",\"\",$G$14)","v":""},{"$f":"IF($G$15=\"\",\"\",$G$15)","v":""},{"$f":"IF($G$16=\"\",\"\",$G$16)","v":""},{"$f":"IF($G$17=\"\",\"\",$G$17)","v":""},{"$f":"IF($G$18=\"\",\"\",$G$18)","v":""}]
[{"$nulls":20},{"$f":"IF($G$19=\"\",\"\",$G$19)","v":""},{"$f":"IF($G$20=\"\",\"\",$G$20)","v":""},{"$f":"IF($G$21=\"\",\"\",$G$21)","v":""},{"$f":"IF($G$22=\"\",\"\",$G$22)","v":""},{"$f":"IF($G$23=\"\",\"\",$G$23)","v":""}]
[{"$nulls":20},{"$f":"IF($G$24=\"\",\"\",$G$24)","v":""},{"$f":"IF($G$25=\"\",\"\",$G$25)","v":""},{"$f":"IF($G$26=\"\",\"\",$G$26)","v":""},{"$f":"IF($G$27=\"\",\"\",$G$27)","v":""},{"$f":"IF($G$28=\"\",\"\",$G$28)","v":""}]
[{"$nulls":20},{"$f":"IF($G$29=\"\",\"\",$G$4)","v":""},{"$f":"IF($G$30=\"\",\"\",$G$30)","v":""},{"$f":"IF($G$31=\"\",\"\",$G$31)","v":""},{"$f":"IF($G$32=\"\",\"\",$G$32)","v":""},{"$f":"IF($G$33=\"\",\"\",$G$33)","v":""}]
[{"$nulls":20},{"$f":"IF($G$34=\"\",\"\",$G$34)","v":""},{"$f":"IF($G$35=\"\",\"\",$G$35)","v":""},{"$f":"IF($G$36=\"\",\"\",$G$36)","v":""},{"$f":"IF($G$37=\"\",\"\",$G$37)","v":""},{"$f":"IF($G$38=\"\",\"\",$G$38)","v":""}]
[{"$nulls":20},{"$f":"IF($G$39=\"\",\"\",$G$39)","v":""},{"$f":"IF($G$40=\"\",\"\",$G$40)","v":""},{"$f":"IF($G$41=\"\",\"\",$G$41)","v":""},{"$f":"IF($G$42=\"\",\"\",$G$42)","v":""},{"$f":"IF($G$43=\"\",\"\",$G$43)","v":""}]
[{"$nulls":20},{"$f":"IF($G$44=\"\",\"\",$G$44)","v":""},{"$f":"IF($G$45=\"\",\"\",$G$45)","v":""},{"$f":"IF($G$46=\"\",\"\",$G$46)","v":""},{"$f":"IF($G$47=\"\",\"\",$G$47)","v":""},{"$f":"IF($G$48=\"\",\"\",$G$48)","v":""}]
[{"$nulls":20},{"$f":"IF($G$49=\"\",\"\",$G$49)","v":""},{"$f":"IF($G$50=\"\",\"\",$G$50)","v":""},{"$f":"IF($G$51=\"\",\"\",$G$51)","v":""},{"$f":"IF($G$52=\"\",\"\",$G$52)","v":""},{"$f":"IF($G$53=\"\",\"\",$G$53)","v":""}]
[{"$nulls":20},{"$f":"IF($G$54=\"\",\"\",$G$54)","v":""},{"$f":"IF($G$55=\"\",\"\",$G$55)","v":""},{"$f":"IF($G$56=\"\",\"\",$G$56)","v":""},{"$f":"IF($G$57=\"\",\"\",$G$57)","v":""},{"$f":"IF($G$58=\"\",\"\",$G$58)","v":""}]
[{"$nulls":20},{"$f":"IF($G$59=\"\",\"\",$G$59)","v":""},{"$f":"IF($G$60=\"\",\"\",$G$60)","v":""},{"$f":"IF($G$61=\"\",\"\",$G$61)","v":""},{"$f":"IF($G$62=\"\",\"\",$G$62)","v":""},{"$f":"IF($G$63=\"\",\"\",$G$63)","v":""}]
[{"$nulls":20},{"$f":"IF($G$64=\"\",\"\",$G$64)","v":""},{"$f":"IF($G$65=\"\",\"\",$G$65)","v":""},{"$f":"IF($G$66=\"\",\"\",$G$66)","v":""},{"$f":"IF($G$67=\"\",\"\",$G$67)","v":""},{"$f":"IF($G$68=\"\",\"\",$G$68)","v":""}]
[{"$nulls":20},{"$f":"IF($G$69=\"\",\"\",$G$69)","v":""},{"$f":"IF($G$70=\"\",\"\",$G$70)","v":""},{"$f":"IF($G$71=\"\",\"\",$G$71)","v":""},{"$f":"IF($G$72=\"\",\"\",$G$72)","v":""},{"$f":"IF($G$73=\"\",\"\",$G$73)","v":""}]
[{"$nulls":20},{"$f":"IF($G$74=\"\",\"\",$G$74)","v":""},{"$f":"IF($G$75=\"\",\"\",$G$75)","v":""},{"$f":"IF($G$76=\"\",\"\",$G$76)","v":""},{"$f":"IF($G$77=\"\",\"\",$G$77)","v":""},{"$f":"IF($G$78=\"\",\"\",$G$78)","v":""}]
[{"$nulls":20},{"$f":"IF($G$79=\"\",\"\",$G$79)","v":""},{"$f":"IF($G$80=\"\",\"\",$G$80)","v":""},{"$f":"IF($G$81=\"\",\"\",$G$81)","v":""},{"$f":"IF($G$82=\"\",\"\",$G$82)","v":""},{"$f":"IF($G$83=\"\",\"\",$G$83)","v":""}]
[{"$nulls":20},{"$f":"IF($G$84=\"\",\"\",$G$84)","v":""},{"$f":"IF($G$85=\"\",\"\",$G$85)","v":""},{"$f":"IF($G$86=\"\",\"\",$G$86)","v":""},{"$f":"IF($G$87=\"\",\"\",$G$87)","v":""},{"$f":"IF($G$88=\"\",\"\",$G$88)","v":""}]
[{"$nulls":20},{"$f":"IF($G$89=\"\",\"\",$G$89)","v":""},{"$f":"IF($G$90=\"\",\"\",$G$90)","v":""},{"$f":"IF($G$91=\"\",\"\",$G$91)","v":""},{"$f":"IF($G$92=\"\",\"\",$G$92)","v":""},{"$f":"IF($G$93=\"\",\"\",$G$93)","v":""}]
[{"$nulls":20},{"$f":"IF($G$94=\"\",\"\",$G$94)","v":""},{"$f":"IF($G$95=\"\",\"\",$G$95)","v":""},{"$f":"IF($G$96=\"\",\"\",$G$96)","v":""},{"$f":"IF($G$97=\"\",\"\",$G$97)","v":""},{"$f":"IF($G$98=\"\",\"\",$G$98)","v":""}]
{"$rows_empty":8}
[{"$nulls":20},{"$f":"IF($D$4=\"\",\"\",$D$4)","v":""},{"$f":"IF($D$5=\"\",\"\",$D$5)","v":""},{"$f":"IF($D$6=\"\",\"\",$D$6)","v":""},{"$f":"IF($D$7=\"\",\"\",$D$7)","v":""},{"$f":"IF($D$8=\"\",\"\",$D$8)","v":""},{"$f":"IF($D$9=\"\",\"\",$D$9)","v":""},{"$f":"IF($D$10=\"\",\"\",$D$10)","v":""}]

{"sheet":"calculations","index":4,"n_rows":53,"n_cols":16,"rows_kept":53,"hidden":true}
{"$rows_empty":8}
[{"$nulls":14},"example pay"]
[{"$nulls":3},"pay period end date","pay date","hours worked","income","Net pay",null,null,false,false,null,null,"2014-01-01",{"v":408.11,"d":"$408.11"}]
[{"$nulls":3},"2012-02-03","2012-02-10",80,{"v":956.9,"d":"$956.90"},{"v":860.32,"d":"$860.32"},null,null,false,false,null,null,"2014-01-08",{"v":413.85,"d":"$413.85"}]
[{"$nulls":3},"2012-01-20","2012-01-27",73.45,{"v":713.29,"d":"$713.29"},{"v":664.99,"d":"$664.99"},null,null,false,false,null,null,"2014-01-15",{"v":900,"d":"$900.00"}]
[{"$nulls":10},false,false,null,null,"2014-01-22",{"v":419.22,"d":"$419.22"}]
[{"$nulls":3},"Pay Period End Date","Pay Date","Hours Worked","Gross Earnings","Net",null,null,false,false,null,null,"2014-01-29",{"v":401.25,"d":"$401.25"}]
[{"$nulls":3},"2014-07-12","2014-07-17",40,{"v":640,"d":"$640.00"},{"v":498.36,"d":"$498.36"},null,null,false,false,null,null,"2014-02-05",{"v":406.72,"d":"$406.72"}]
[{"$nulls":3},"2014-07-05","2014-07-10",22.5,{"v":360,"d":"$360.00"},{"v":255.46,"d":"$255.46"},null,null,false,false,null,null,"2014-02-12",{"v":405.22,"d":"$405.22"}]
[{"$nulls":3},"2014-06-28","2014-07-03",40,{"v":640,"d":"$640.00"},{"v":498.36,"d":"$498.36"},null,null,false,false,null,null,"2014-02-19",{"v":751,"d":"$751.00"}]
[{"$nulls":3},"2014-06-21","2014-06-26",32,{"v":512,"d":"$512.00"},{"v":391.68,"d":"$391.68"},null,null,false,false,null,null,"2014-02-26",{"v":403.22,"d":"$403.22"}]
[{"$nulls":3},"2014-06-14","2014-06-19",40,{"v":640,"d":"$640.00"},{"v":498.36,"d":"$498.36"},null,null,false,false,null,null,"2014-03-05",{"v":401.11,"d":"$401.11"}]
[{"$nulls":3},"2014-06-07","2014-06-12",40,{"v":640,"d":"$640.00"},{"v":498.36,"d":"$498.36"},null,null,false,false,null,null,"2014-03-12",{"v":417.22,"d":"$417.22"}]
[{"$nulls":3},"2014-05-31","2014-06-05",32,{"v":512,"d":"$512.00"},{"v":391.66,"d":"$391.66"},null,null,false,false,null,null,"2014-03-19",{"v":427.63,"d":"$427.63"}]
[{"$nulls":3},"2014-05-24","2014-05-29",40,{"v":640,"d":"$640.00"},{"v":498.36,"d":"$498.36"},null,null,false,false,null,null,"2014-03-26",{"v":395.22,"d":"$395.22"}]
[{"$nulls":3},"2014-05-17","2014-05-22",34,{"v":544,"d":"$544.00"},{"v":418.36,"d":"$418.36"},null,null,false,false,null,null,"2014-04-02",{"v":385.22,"d":"$385.22"}]
[{"$nulls":10},false,false,null,null,"2014-04-09",{"v":421.25,"d":"$421.25"}]
[{"$nulls":10},false,false,null,null,"2014-04-16",{"v":412.22,"d":"$412.22"}]
[{"$nulls":10},false,false,null,null,"2014-04-23",{"v":412.85,"d":"$412.85"}]
[{"$nulls":10},false,false,null,null,"2014-04-30",{"v":421.22,"d":"$421.22"}]
[{"$nulls":10},false,false,null,null,"2014-05-07",{"v":408.2,"d":"$408.20"}]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(AND(E44>0,E44<100),E44)","v":false}]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},false]
[{"$nulls":3},{"$f":"COUNT(D33:D50)","v":0}]
[{"$nulls":3},{"$f":"SUM(D33:D50)","v":0}]
[{"$nulls":3},{"$f":"D52/D51","v":{"$error":"#DIV/0!"}}]

{"sheet":"Self-Employment","index":5,"n_rows":67,"n_cols":28,"rows_kept":67,"merged":[[1,1,1,18],[3,14,6,16]]}
[]
[null,"Self-Employment Calculator"]
[]
[null,null,"Sampling Type:",null,"Expenses:",null,"Number of Months Sampled:",{"$nulls":3},"Applicable Oregon Min Wage:",{"$nulls":3},{"$f":"IF(ISERROR(Q9),\"\",(Q9))","v":""}]
[null,null,"unselected",{"$nulls":17},1]
[{"$nulls":20},2]
[{"$nulls":20},3]
[null,null,"Start Month:",{"$nulls":17},4]
[null,null,"2018-01-01",1,2,3,4,5,6,7,8,9,10,11,12,{"$f":"IF(G$5>0,\"copy line >>\",\"\")","v":""},{"$f":"IF(ISERROR(B47),\"\",(B47))","v":""}," ",null,null,5]
[{"$nulls":3},{"$f":"DATE(YEAR(C9),MONTH(C9),DAY(C9))","v":"2018-01-01"},{"$f":"DATE(YEAR(D10),MONTH(D10)+1,DAY(55))","v":"2018-02-24"},{"$f":"DATE(YEAR(E10),MONTH(E10)+1,DAY(55))","v":"2018-03-24"},"2018-04-24","2018-05-24","2018-06-24","2018-07-24","2018-08-24","2018-09-24","2018-10-24","2018-11-24","2018-12-24",{"$f":"IF(G$5>0,\"copy line >>\",\"\")","v":""},{"$nulls":4},6]
[{"$nulls":15},{"$f":"IF(G$5>0,\"copy line >>\",\"\")","v":""},{"$f":"B49","v":""},{"$nulls":3},7]
[{"$nulls":15},{"$f":"IF(G$5>0,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=1,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B50),\"Please Enter Applicable Oregon Minimum Wage\")","v":""},{"$nulls":3},8]
[{"$nulls":15},{"$f":"IF(G$5>1,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=2,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B51),\"Please Enter Applicable Oregon Minimum Wage\")","v":""},{"$nulls":3},9]
[{"$nulls":15},{"$f":"IF(G$5>2,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=3,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B52),\"Please Enter Applicable Oregon Minimum Wage\")","v":""},{"$nulls":3},10]
[{"$nulls":15},{"$f":"IF(G$5>3,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=4,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B53),\"Please Enter Applicable Oregon Minimum Wage\")","v":""},{"$nulls":3},11]
[{"$nulls":15},{"$f":"IF(G$5>4,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=5,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B54),\"Please Enter Applicable Oregon Minimum Wage\")","v":""},{"$nulls":3},12]
[{"$nulls":15},{"$f":"IF(G$5>5,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=6,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B55),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>6,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=7,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B56),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>7,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=8,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B57),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>8,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=9,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B58),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>9,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=10,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B59),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>10,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=11,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B60),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[{"$nulls":15},{"$f":"IF(G$5>11,\"copy line >>\",\"\")","v":""},{"$f":"IFERROR(IF($G$5=12,\"Coded Income: \"&TEXT($V$34,\"######.00\")&\" - Avg. Hrs/Wk for JPI/Stu: \"&TEXT($W$30,\"####.00\")&\" - Avg Hrs/Wk for ABAWD: \"&TEXT($V$47,\"####.00\"),B61),\"Please Enter Applicable Oregon Minimum Wage\")","v":""}]
[]
[]
[]
[]
[]
[]
[{"$nulls":21},"JPI/Stu:",{"$f":"$V$34/K5/4.3","v":{"$error":"#DIV/0!"}}]
[]
[]
[{"$nulls":21},"Monthly Income"]
[{"$nulls":21},{"$f":"T43/T44","v":{"$error":"#DIV/0!"}}]
[null,null,"Monthly Total:",{"$f":"IF($G$5<1,\"\",SUM(D11:D33))","v":""},{"$f":"IF($G$5<2,\"\",SUM(E11:E33))","v":""},{"$f":"IF($G$5<3,\"\",SUM(F11:F33))","v":""},{"$f":"IF($G$5<4,\"\",SUM(G11:G33))","v":""},{"$f":"IF($G$5<5,\"\",SUM(H11:H33))","v":""},{"$f":"IF($G$5<6,\"\",SUM(I11:I33))","v":""},{"$f":"IF($G$5<7,\"\",SUM(J11:J33))","v":""},{"$f":"IF($G$5<8,\"\",SUM(K11:K33))","v":""},{"$f":"IF($G$5<9,\"\",SUM(L11:L33))","v":""},{"$f":"IF($G$5<10,\"\",SUM(M11:M33))","v":""},{"$f":"IF($G$5<11,\"\",SUM(N11:N33))","v":""},{"$f":"IF($G$5<12,\"\",SUM(O11:O33))","v":""}]
[null,null,"Running Total:",{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"IF(E35=\"\",\"\",E35+D36)","v":""},{"$f":"IF(F35=\"\",\"\",F35+E36)","v":""},"","","","","","","","",""]
[]
[{"$nulls":21},"AB Exempt (SEC) + 1870.50:",{"$f":"$V$34/2/7.25/4.3","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"yes\",IF(V34>=1870.5,\"Participant is ABAWD Exempt as income is over $1870.50/mo SEC, converted hours from income are $\"&TEXT(V34,\"####.00\")&\"/mo * 50%(SEC Exclusion) / $7.25/hr (Fed MinWage) / 4.3wks/mo = \"&TEXT(W38,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false},null,"AB Exempt (SEN) + 935.25 :",{"$f":"$V$34/7.25/4.3","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"no\",IF(V34>=935.25,\"Participant is ABAWD Exempt as income over $935.25/mo SEN, converted hours from income are $\"&TEXT(V34,\"####.00\")&\"/mo / $7.25/hr (Fed MinWage) / 4.3wks/mo = \"&TEXT(AA38,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false}]
[{"$nulls":21},"AB Comp 20-29 (SEC) + 1160.00:",{"$f":"$V$34/2/7.25/4","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"yes\",IF(AND(V34>=1160,V34<1870.49),\"Participant is ABAWD compliant, but not exempt.  Income is under $1870.50 SEC but above $1160.00 SEC.  Coding 20 hours on TRACS case plan.  Hour conversion is as follows: $\"&TEXT(V34,\"####.00\")&\"/mo * 50% (SEC exclusion) / $7.25/hr (FedMinWage) / 4wks/mo = \"&TEXT(W39,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false},null,"AB Comp 20-29 (SEn) + 580.00:",{"$f":"$V$34/7.25/4","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"no\",IF(AND(V34>=580,V34<935.24),\"Participant is ABAWD compliant, but not exempt.  Income is under $935.24 SEN but above $580.00 SEN.  Coding 20 hours on TRACS case plan.  Hour conversion is as follows: $\"&TEXT(V34,\"####.00\")&\"/mo / $7.25/hr (FedMinWage) / 4wks/mo = \"&TEXT(AA39,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false}]
[{"$nulls":21},"AB Mandatory (SEC) - 1160.00",{"$f":"$V$34/2/7.25/4","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"yes\",IF(V34<1160,\"Participant is ABAWD Mandatory as income is under $1160.00/mo SEC.  Hour conversion is as folows: $\"&TEXT(V34,\"####.00\")&\"/mo * 50% (SEC exclusion) / $7.25/hr (FedMinWage) / 4wks/mo = \"&TEXT(W40,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false},null,"AB Mandatory (SEN) - 580.00",{"$f":"$V$34/7.25/4","v":{"$error":"#DIV/0!"}},{"$f":"IF($E$5=\"no\",IF(V34<580,\"Participant is ABAWD Mandatory as income is under $580.00/mo SEN.  Hour conversion is as folows: $\"&TEXT(V34,\"####.00\")&\"/mo / $7.25/hr (FedMinWage) / 4wks/mo = \"&TEXT(AA40,\"##.00\")&\"hrs/mo. \",FALSE),FALSE)","v":false}]
[]
[{"$nulls":21},{"$f":"(IF(X38=FALSE,\"\",X38))&(IF(X39=FALSE,\"\",X39))&(IF(X40=FALSE,\"\",X40))&(IF(AB38=FALSE,\"\",AB38))&(IF(AB39=FALSE,\"\",AB39))&(IF(AB40=FALSE,\"\",AB40))","v":""}]
[{"$nulls":19},{"$f":"SUM(D35:O35)","v":0}]
[{"$nulls":19},{"$f":"G5","v":0}]
[{"$nulls":14},{"v":11,"d":"$11.00"}]
[null,null,{"$f":"\"Participant submitted verification of their self-employment income in the form of \"&J46&\". The total gross income was \"&DOLLAR(T43,2)&\" over a period of \"&T44&\" months. \"&DOLLAR(T43,2)&\"/\"&T44&\"mo = \"&DOLLAR(V34,2)&\"/mo in average monthly income. \"&\"For JPI/Stu calculations: using current Oregon local minimum wage of $\"&TEXT(K5,\"####.00\")&\"/hr this income converts to \"&TEXT(W30,\"####.00\")&\"hrs/wk of work. \"&V42&J49","v":{"$error":"#DIV/0!"}},null,"Unselected",{"$nulls":4},{"$f":"IF(C5=\"Unselected\",\"<<<Please Select Sampling Type>>>\",IF(OR(C5=E47),E47,IF(OR(C5=E48),E48)))","v":"<<<Please Select Sampling Type>>>"},{"$nulls":4},{"v":11.25,"d":"$11.25"}]
[null,{"$f":"C46","v":{"$error":"#DIV/0!"}},null,null,"Monthly Totals",{"$nulls":9},{"v":12.5,"d":"$12.50"},{"$nulls":6},{"$f":"(IF(X38=FALSE,\"\",W38))&(IF(X39=FALSE,\"\",W39))&(IF(X40=FALSE,\"\",W40))&(IF(AB38=FALSE,\"\",AA38))&(IF(AB39=FALSE,\"\",AA39))&(IF(AB40=FALSE,\"\",AA40))","v":""}]
[{"$nulls":4},"Itemized/Daily Monthly Income"]
[null,{"$f":"IF(G$5>0,C49,\"\")","v":""},{"$f":"TEXT(D10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(D35,2)&\".\"","v":{"$error":"#VALUE!"}},{"$nulls":6},{"$f":"IF(E5=\"\",\"<<<Please Select If Any Expeses>>>\",IF(OR(E5=E50),F50,IF(OR(E5=E51),F51)))","v":"<<<Please Select If Any Expeses>>>"}]
[null,{"$f":"IF(G$5>1,C50,\"\")","v":""},{"$f":"TEXT(E10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(E35,2)&\".\"","v":{"$error":"#VALUE!"}},null,"yes","The Participant reports they have expenses in the form of <<NARRATE HERE>>."]
[null,{"$f":"IF(G$5>2,C51,\"\")","v":""},{"$f":"TEXT(F10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(F35,2)&\".\"","v":{"$error":"#VALUE!"}},null,"no","The Participant reports that they do not have countable expenses with this work."]
[null,{"$f":"IF(G$5>3,C52,\"\")","v":""},{"$f":"TEXT(G10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(G35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>4,C53,\"\")","v":""},{"$f":"TEXT(H10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(H35,2)&\".\"","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(C5=E47),\"monthly totals. \",IF(OR(C5=E48),\"itemized/daily reporting of income during the month that I totalled. \"))","v":false}]
[null,{"$f":"IF(G$5>5,C54,\"\")","v":""},{"$f":"TEXT(I10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(I35,2)&\".\"","v":{"$error":"#VALUE!"}},null,{"$f":"IF(OR(E5=E50),\"They have expenses associated with there self employed income. \",IF(OR(E5=E51),\"The report that they do not have expenses associated with this income.\"))","v":false}]
[null,{"$f":"IF(G$5>6,C55,\"\")","v":""},{"$f":"TEXT(J10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(J35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>7,C56,\"\")","v":""},{"$f":"TEXT(K10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(K35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>8,C57,\"\")","v":""},{"$f":"TEXT(L10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(L35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>9,C58,\"\")","v":""},{"$f":"TEXT(M10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(M35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>10,C59,\"\")","v":""},{"$f":"TEXT(N10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(N35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G$5>11,C60,\"\")","v":""},{"$f":"TEXT(O10,\"mm/yyy\")&\" gross monthly income was \"&DOLLAR(O35,2)&\".\"","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(G17>2,C61,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Missing Check","index":6,"n_rows":51,"n_cols":11,"rows_kept":51,"merged":[[1,1,1,9],[12,4,16,7],[17,5,17,6]]}
[]
[null,"Missing Check Calculator"]
[]
[{"$nulls":5},"Date","Gross Amount","YTD"]
[{"$nulls":4},"1st Check:"]
[{"$nulls":4},"2nd Check:"]
[{"$nulls":4},"Days Between:",{"$f":"IF(F6=0,\"\",F6-F5)","v":""},{"$f":"IFERROR(F7/2,\"\")","v":""}]
[]
[{"$nulls":4},"Missing Check:",{"$f":"IFERROR(F5+G7,\"\")","v":""},{"$f":"H9-H5","v":{"v":0,"d":"0.00"}},{"$f":"H6-G6","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":4},{"$f":"IF(H6>0,D41,\"\")","v":""}]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"IF(F18<>\"\",\"copy here >>\",\"\")","v":""},{"$f":"E13","v":""},{"$nulls":4}," "]
[{"$nulls":7}," "]
[{"$nulls":10}," "]
[]
[]
[{"$nulls":5},"frequency of pay:","unselected"]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"IF(F9>0, \"There is a missing check, so used a YTD calculation. 1st Paystub: \"&TEXT(F5,\"mm/dd/yyy\")&\" = \"&DOLLAR(G5,2)&\" with a YTD of \"&DOLLAR(H5,2)&\". 2nd Paystub: \"&TEXT(F6,\"mm/dd/yyy\")&\" = \"&DOLLAR(G6,2)&\" with a YTD of \"&DOLLAR(H6,2)&\". The missing check amount is \"&DOLLAR(G9,2)&\" (CALC: \"&DOLLAR(H6,2)&\" - \"&DOLLAR(G6,2)&\" - \"&DOLLAR(H5,2)&\") on the approximate date of \"&TEXT(F9,\"mm/dd/yyy\")&\".\")","v":"There is a missing check, so used a YTD calculation. 1st Paystub: 01/00/1900 = $0.00 with a YTD of $0.00. 2nd Paystub: 01/00/1900 = $0.00 with a YTD of $0.00. The missing check amount is $0.00 (CALC: $0.00 - $0.00 - $0.00) on the approximate date of ."}]
[]
[]
[]
[]
[{"$nulls":3},"unselected",{"$nulls":3},{"$f":"I10*4.3","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"weekly",{"$nulls":3},{"$f":"I10*2.15","v":0}]
[{"$nulls":3},"bi-weekly",{"$nulls":3},{"$f":"I10*2","v":0}]
[{"$nulls":3},"twice a month",{"$nulls":3},{"$f":"I10*1","v":0}]
[{"$nulls":3},"monthly"]
[{"$nulls":3},"other"]

{"sheet":"Missing Check Old","index":7,"n_rows":49,"n_cols":11,"rows_kept":49,"hidden":true,"merged":[[1,1,1,9],[7,3,7,4],[10,4,15,7]]}
[]
[null,"Missing Check Calculator"]
[]
[{"$nulls":3},"1st Check Date:",null,"1st Check Amount:",null,"1st Check YTD:"]
[null,null,{"$f":"IF(E6=0,\"\",E6-E4)","v":""},"Days Between",{"$f":"IFERROR(C5/2,\"\")","v":""},"Missing Check Amount:",{"$f":"I5-I4","v":{"v":0,"d":"0.00"}},"Missing Check YTD:",{"$f":"I6-G6","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"2nd Check Date:",null,"2nd Check Amount:",null,"2nd Check YTD:"]
[]
[null,null," ","Likely Missing Check Date: ",null,{"$f":"IFERROR(E4+E5,\"\")","v":""}]
[]
[]
[{"$nulls":4},{"$f":"IF(I6>0,D39,\"\")","v":""}]
[]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":5},{"$f":"IF(I6>0,\"COPY HERE >>>>\",\"\")","v":""},{"$f":"E11","v":""}," "]
[{"$nulls":10}," "]
[]
[]
[{"$nulls":5},"frequency of pay:","unselected"]
{"$rows_empty":17}
[{"$nulls":3},{"$f":"\"There is a missing check, so used a YTD calculation. The first check is dated \"&TEXT(E4,\"mm/dd/yyy\")&\" and the second check is dated \"&TEXT(E6,\"mm/dd/yyy\")&\". Gross income on the first check is \"&DOLLAR(G4,2)&\" with a YTD of \"&DOLLAR(I4,2)&\". Gross income on the second check is \"&DOLLAR(G6,2)&\" with a YTD of  \"&DOLLAR(I6,2)&\". The missing check amount is \"&DOLLAR(G5,2)&\" (\"&DOLLAR(I6,2)&\" - \"&DOLLAR(G6,2)&\" - \"&DOLLAR(I4,2)&\") on the approximate date of \"&TEXT(F8,\"mm/dd/yyy\")&\".\"","v":"There is a missing check, so used a YTD calculation. The first check is dated 01/00/1900 and the second check is dated 01/00/1900. Gross income on the first check is $0.00 with a YTD of $0.00. Gross income on the second check is $0.00 with a YTD of  $0.00. The missing check amount is $0.00 ($0.00 - $0.00 - $0.00) on the approximate date of ."}]
[]
[]
[]
[]
[{"$nulls":3},"unselected",{"$nulls":3},{"$f":"I8*4.3","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"weekly",{"$nulls":3},{"$f":"I8*2.15","v":0}]
[{"$nulls":3},"bi-weekly",{"$nulls":3},{"$f":"I8*2","v":0}]
[{"$nulls":3},"twice a month",{"$nulls":3},{"$f":"I8*1","v":0}]
[{"$nulls":3},"monthly"]
[{"$nulls":3},"other"]

{"sheet":"Pay Rate Conversion","index":8,"n_rows":23,"n_cols":9,"rows_kept":23,"merged":[[1,1,1,6],[6,2,6,4],[7,2,7,4],[10,2,17,5],[18,2,18,3],[22,7,23,10]]}
[]
[null,"Pay Rate Conversion Calculator"]
[]
[null,null,"Old Rate:",null,null,"New Rate:"]
[null,null,{"v":11.25,"d":"$11.25"}]
[{"$nulls":8},{"v":11,"d":"$11.00"}]
[null,null,"Old Rate Earnings:",{"$nulls":4},{"$f":"F5/C5","v":{"v":0,"d":"0.0000"}},{"v":11.25,"d":"$11.25"}]
[null,null,"Adjusted New Rate Earnings:",null,null,{"$f":"F7*H7","v":{"v":0,"d":"$0.00"}},null,null,{"v":12.5,"d":"$12.50"}]
[]
[]
[null,null,{"$f":"IF(F7>0,H23,\"\")","v":""}]
{"$rows_empty":7}
[null,null,{"$f":"IF(F7>0,\"COPY HERE >>>>\",\"\")","v":""},null,{"$f":"C11","v":""}," "]
[]
[]
[]
[{"$nulls":7},{"$f":"\"The participant's pay rate has increased to \" &DOLLAR(F5,2)&\"/hr from \" &DOLLAR(C5,2)&\"/hr. Because income was representative at previous pay rate, and the only factor changed is the increased pay rate, we will multiply the participant's earnings by \"&ROUND(H7,4)& \" (\"&DOLLAR(F5,2)&\"/\"&DOLLAR(C5,2)&\") which is the increase due to the new pay rate. The participant's income was calculated to be \"&DOLLAR(F7,2)&\" at the old pay rate. The adjusted income with new pay rate for this participant is \"&DOLLAR(F8,2)&\".\"","v":"The participant's pay rate has increased to $0.00/hr from $11.25/hr. Because income was representative at previous pay rate, and the only factor changed is the increased pay rate, we will multiply the participant's earnings by 0 ($0.00/$11.25) which is the increase due to the new pay rate. The participant's income was calculated to be $0.00 at the old pay rate. The adjusted income with new pay rate for this participant is $0.00."}]

{"sheet":"Day Care","index":9,"n_rows":207,"n_cols":30,"rows_kept":207,"merged":[[1,1,1,10],[3,3,3,4],[3,7,3,8],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[32,9,32,11],[78,1,79,4]]}
[]
[null,"Day Care Hour Calculator"]
[]
[{"$nulls":3},"                        Name of Parent One:",{"$nulls":3},"           Name of Parent Two:"]
[]
[null,null,"Both parents work this day?:",null,"Start:","Stop:",null,"Start:","Stop:","Day Care Needed:"]
[null,null,"no","Monday",{"$nulls":5},{"$f":"IF(C7=\"yes\",AD120,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"no","Tuesday",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,null,"no","Wednesday",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,null,"no","Thursday",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,null,"no","Friday",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,null,"no","Saturday",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,null,"no","Sunday",{"$nulls":5},{"v":0,"d":"0.00"}]
[]
[{"$nulls":8},"weekly total:",{"$f":"SUM(W91:W97)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[]
[null,null,{"$f":"I20","v":" "},{"$nulls":4}," ",{"$f":"W104","v":" "}," ",null,null," "]
[null,null," ",{"$nulls":4}," "," ",{"$nulls":3}," "]
[null,null," ",{"$nulls":4}," "," ",{"$nulls":3}," "]
[null,null," ",{"$nulls":4}," "," "," ",null,null," "]
[null,null,"",{"$nulls":4}," ",""," ",null,null," "]
[null,null," ",{"$nulls":4}," "," "," ",null,null," "]
[null,null," ",{"$nulls":4}," ",{"$f":"W110","v":" "}," ",null,null," "]
[null,null," ",{"$nulls":4}," "," "," ",null,null," "]
[null,null,"No daycare is needed",{"$nulls":4}," ",{"$f":"D134","v":"No daycare is needed"}," ",null,null," "]
[null,null,"The most childcare needed on any day is: 0 hrs.  As such allowable hours must be determined from this highest need amount. CALC: 0hrs/day*0days with overlap/wk = 0hrs/mo allowed",{"$nulls":4}," ",{"$f":"H92","v":"The most childcare needed on any day is: 0 hrs.  As such allowable hours must be determined from this highest need amount. CALC: 0hrs/day*0days with overlap/wk = 0hrs/mo allowed"}," ",null,null," "]
{"$rows_empty":38}
[{"$nulls":13},"COPY Narrative at TOP OF PAGE ","in the green box."]
[]
[]
[]
[]
[]
[]
[{"$nulls":6},{"$f":"\"Does \"&F4&\" have consistent daily work schedule?:\"","v":"Does  have consistent daily work schedule?:"},"no"]
[{"$nulls":6},{"$f":"\"Does \"&J4&\" have consistent daily work schedule?:\"","v":"Does  have consistent daily work schedule?:"},"no"]
[{"$nulls":12},{"$f":"J15*4.3","v":0}]
[{"$nulls":12},{"$f":"ROUNDUP(M77,2)","v":0}]
[null,"NOTE: Times must be written in the format of 0:00 AM/PM (i.e. 8:00 AM or 5:00 PM, include a space between the time and AM/PM)."]
[]
[]
[]
[null,null,{"$f":"IF(AND(F83=TRUE),E83&\", \",\"\")","v":""},null,{"$f":"IF(C7=\"yes\",D7,\"\")","v":""},{"$f":"IF(AND(E7=E8,F7=F8,H7=H8,I7=I8,C7=\"yes\",C8=\"yes\"),TRUE,FALSE)","v":false},null,{"$f":"IF(C7=$Z$120,I83,\"0\")","v":"0"},{"$f":"\"Monday \"&PROPER($F$4)&\" works from \"&TEXT(E7,\"h:mm am/pm\")&\" until \"&TEXT(F7,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H7,\"h:mm am/pm\")&\" until \"&TEXT(I7,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X91,\"h:mm am/pm\")&\" until \"&TEXT(Y91,\"h:mm am/pm\")&\" which is \"&TEXT(J7,\"0.00\")&\" hours.\"","v":"Monday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,{"$f":"IF(AND(F84=TRUE),C83&E84&\", \",\"\")","v":""},null,"",false,{"$f":"IF(F83=TRUE,C83&H84,)","v":0},"0",{"$f":"\"Tuesday \"&PROPER($F$4)&\" works from \"&TEXT(E8,\"h:mm am/pm\")&\" until \"&TEXT(F8,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H8,\"h:mm am/pm\")&\" until \"&TEXT(I8,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X92,\"h:mm am/pm\")&\" until \"&TEXT(Y92,\"h:mm am/pm\")&\" which is \"&TEXT(J8,\"0.00\")&\" hours.\"","v":"Tuesday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,"",null,"",false,0,"0",{"$f":"\"Wednesday \"&PROPER($F$4)&\" works from \"&TEXT(E9,\"h:mm am/pm\")&\" until \"&TEXT(F9,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H9,\"h:mm am/pm\")&\" until \"&TEXT(I9,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X93,\"h:mm am/pm\")&\" until \"&TEXT(Y93,\"h:mm am/pm\")&\" which is \"&TEXT(J9,\"0.00\")&\" hours.\"","v":"Wednesday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,"",null,"",false,0,"0",{"$f":"\"Thursday \"&PROPER($F$4)&\" works from \"&TEXT(E10,\"h:mm am/pm\")&\" until \"&TEXT(F10,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H10,\"h:mm am/pm\")&\" until \"&TEXT(I10,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X94,\"h:mm am/pm\")&\" until \"&TEXT(Y94,\"h:mm am/pm\")&\" which is \"&TEXT(J10,\"0.00\")&\" hours.\"","v":"Thursday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,"",null,"",false,0,"0",{"$f":"\"Friday \"&PROPER($F$4)&\" works from \"&TEXT(E11,\"h:mm am/pm\")&\" until \"&TEXT(F11,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H11,\"h:mm am/pm\")&\" until \"&TEXT(I11,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X95,\"h:mm am/pm\")&\" until \"&TEXT(Y95,\"h:mm am/pm\")&\" which is \"&TEXT(J11,\"0.00\")&\" hours.\"","v":"Friday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,"",null,"",false,0,"0",{"$f":"\"Saturday \"&PROPER($F$4)&\" works from \"&TEXT(E12,\"h:mm am/pm\")&\" until \"&TEXT(F12,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H12,\"h:mm am/pm\")&\" until \"&TEXT(I12,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X96,\"h:mm am/pm\")&\" until \"&TEXT(Y96,\"h:mm am/pm\")&\" which is \"&TEXT(J12,\"0.00\")&\" hours.\"","v":"Saturday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[null,null,"",null,"",false,0,"0",{"$f":"\"Sunday \"&PROPER($F$4)&\" works from \"&TEXT(E13,\"h:mm am/pm\")&\" until \"&TEXT(F13,\"h:mm am/pm\")&\" and \"&PROPER($J$4)&\" works from \"&TEXT(H13,\"h:mm am/pm\")&\" until \"&TEXT(I13,\"h:mm am/pm\")&\", coverage needed from \"&TEXT(X97,\"h:mm am/pm\")&\" until \"&TEXT(Y97,\"h:mm am/pm\")&\" which is \"&TEXT(J13,\"0.00\")&\" hours.\"","v":"Sunday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."}]
[{"$nulls":23},"parent in","parent out"]
[{"$nulls":7},{"$f":"\"There are a total of \"&TEXT(J15,\"0.00\")&\" hours of child care needed per week, (*4.3 is \"&M78&\") in monthly hours needed.\"","v":"There are a total of 0.00 hours of child care needed per week, (*4.3 is 0) in monthly hours needed."},{"$nulls":14},{"$f":"IF(C7=\"yes\",J7,0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(OR(E7>H7),E7,H7)","v":"00:00:00"},{"$f":"IF(OR(F7<I7),F7,I7)","v":"00:00:00"},{"$f":"TEXT(Y91-X91,\"h:mm\")","v":"0:00"}]
[{"$nulls":7},{"$f":"\"The most childcare needed on any day is: \"&W98&\" hrs\"&\".  As such allowable hours must be determined from this highest need amount. CALC: \"&W98&\"hrs/day*\"&X98&\"days with overlap/wk = \"&(X100)&\"hrs/mo allowed\"","v":"The most childcare needed on any day is: 0 hrs.  As such allowable hours must be determined from this highest need amount. CALC: 0hrs/day*0days with overlap/wk = 0hrs/mo allowed"},{"$nulls":14},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[{"$nulls":3},{"$f":"IF(AND(F83=FALSE,C7=\"yes\"),I83,IF(AND(F83=TRUE,F84=TRUE),G85,IF(OR(C7=\"no\",\"\"),IF(AND(F83=TRUE,F84=FALSE),G84,\"\"))))","v":{"$error":"#VALUE!"}},{"$nulls":18},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[{"$nulls":3},{"$f":"IF(AND(F84=FALSE,C8=\"yes\"),I84,IF(AND(F84=TRUE,F85=TRUE),G86,IF(OR(C8=\"no\",\"\"),IF(AND(F84=TRUE,F85=FALSE),G85,\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"IF(F83=F84,G95)","v":"0"},null,{"$f":"IF(F83=FALSE,H83,G84)","v":"0"},{"$nulls":15},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[null,null,{"$f":"IF(AND(F83=TRUE,F84=TRUE),G85)","v":false},{"$f":"IF(AND(F85=FALSE,C9=\"yes\"),I85,IF(AND(F85=TRUE,F86=TRUE),G87,IF(OR(C9=\"no\",\"\"),IF(AND(F85=TRUE,F86=FALSE),G86,\"\"))))","v":{"$error":"#VALUE!"}},"0",{"$f":"IF(F83=TRUE,G84,G83)","v":0},{"$f":"IF(F84=FALSE,H84,G85)","v":"0"},{"$nulls":15},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[null,null,{"$f":"IF(AND(F84=TRUE,F85=TRUE),G86)","v":false},{"$f":"IF(AND(F86=FALSE,C10=\"yes\"),I86,IF(AND(F86=TRUE,F87=TRUE),G88,IF(OR(C10=\"no\",\"\"),IF(AND(F86=TRUE,F87=FALSE),G87,\"\"))))","v":{"$error":"#VALUE!"}},"0",{"$f":"IF(F84=TRUE,G85,G84)","v":0},"0",{"$nulls":4},"02:15:00",{"$f":"TIMEVALUE(\"2:15\")","v":"02:15:00"},null,24,{"$nulls":7},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[null,null,{"$f":"IF(AND(F85=TRUE,F86=TRUE),G87)","v":false},{"$f":"IF(AND(F87=FALSE,C11=\"yes\"),I87,IF(AND(F87=TRUE,F88=TRUE),G89,IF(OR(C11=\"no\",\"\"),IF(AND(F87=TRUE,F88=FALSE),G88,\"\"))))","v":{"$error":"#VALUE!"}},"0",0,"0",{"$nulls":15},{"v":0,"d":"0.00"},"00:00:00","00:00:00","0:00"]
[null,null,{"$f":"IF(AND(F86=TRUE,F87=TRUE),G88)","v":false},{"$f":"IF(AND(F88=FALSE,C12=\"yes\"),I88,IF(AND(F88=TRUE,F89=TRUE),G90,IF(OR(C12=\"no\",\"\"),IF(AND(F88=TRUE,F89=FALSE),G89,))))","v":{"$error":"#VALUE!"}},"0",0,"0",{"$nulls":15},{"$f":"MAX(W91:W97)","v":{"v":0,"d":"0.00"}},{"$f":"COUNTIF(W91:W97,\"<>0\")","v":0}]
[null,null,{"$f":"IF(AND(F87=TRUE,F88=TRUE),G89)","v":false},{"$f":"IF(AND(F89=FALSE,C13=\"yes\"),I89,IF(AND(F89=TRUE,F90=TRUE),G91,IF(OR(C13=\"no\",\"\"),IF(AND(F89=TRUE,F90=FALSE),G90,))))","v":{"$error":"#VALUE!"}},"0",0,"0",{"$nulls":16},{"$f":"(W98*X98*4.3)","v":0}]
[{"$nulls":4},0,0,"0",{"$nulls":16},{"$f":"ROUNDUP(X99,0)","v":0}]
[{"$nulls":5},0,0]
[{"$nulls":5},0,null,null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":3},"  ","  ","  ","  "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null," "," "," "," "," "," "]
[{"$nulls":5},{"$f":"IF(G104=\"0\",F103,G104)","v":""},{"$f":"IF(OR(C7=\"no\"),\"\",IF(AND(F83=FALSE,C7=\"yes\"),H83,IF(AND(F83=TRUE,F84=FALSE),G84,\"0\")))","v":""},{"$f":"IF(F104=F105,\"0\",F104)","v":"0"},{"$f":"IF(AND(H104=\"0\"),H103,H104)","v":" "}," ",{"$f":"IF(J104=J105,\"\",J104)","v":""},{"$f":"IF(J104=J105,\"0\",J104)","v":"0"},{"$f":"IF(AND(L104=\"0\"),L103,L104)","v":" "}," ",{"$f":"IF(N104=N105,\"\",N104)","v":""},{"$f":"IF(N104=N105,\"0\",N104)","v":"0"},{"$f":"IF(AND(P104=\"0\"),P103,P104)","v":" "}," ",{"$f":"IF(R104=R105,\"\",R104)","v":""},{"$f":"IF(R104=R105,\"0\",R104)","v":"0"},{"$f":"IF(AND(T104=\"0\"),T103,T104)","v":" "},{"$f":"IF(AND(U104=\"0\"),U103,U104)","v":" "},{"$f":"IF(V104=\"0\",\"\",V104)","v":" "}]
[{"$nulls":5},"",{"$f":"IF(OR(C8=\"no\"),\"0\",IF(AND(F84=FALSE,C8=\"yes\",F83=FALSE),H84,IF(AND(F84=TRUE,F85=FALSE),G85,\"0\")))","v":"0"},"0","0"," "," "," "," "," ","","0","0"," "," "," "," "," "," "]
[{"$nulls":5},"","0","0","0","0","","0"," "," ","","0","0","0","0","0"," "," "," "]
[{"$nulls":4},{"$f":"IF(C7=\"yes\",E83,\"no\")","v":"no"},"","0","0","0","0","","0","0"," "," "," "," "," ","","0","0"," "," "]
[{"$nulls":3},{"$f":"IF(E109=\"no\",\"\",E108)","v":""},"no","","0","0","0","0","","0","0","0","","0"," "," ","","0","0","0",""]
[{"$nulls":4},"no","","0","0","0","0","","0","0","0","","0","0"," "," "," "," "," "," "]
[{"$nulls":4},"no","","0","0","0","0","0","0","0","0","0","0","0","0","0","0"," "," "," "]
[{"$nulls":4},"no",{"$nulls":17},{"$f":"IF(V111=\"0\",\"\",V111)","v":0}]
[{"$nulls":4},"no",null,null,{"$f":"IF(F112=F113,\"\",F112)","v":""},{"$nulls":7},"00:00:00"]
[{"$nulls":4},"no",{"$nulls":10},"00:15:00"]
[{"$nulls":4},{"$f":"D133","v":"No daycare is needed"},{"$nulls":10},"00:30:00"]
[{"$nulls":4},{"$f":"H91","v":"There are a total of 0.00 hours of child care needed per week, (*4.3 is 0) in monthly hours needed."},{"$nulls":10},"00:45:00"]
[{"$nulls":15},"01:00:00"]
[{"$nulls":15},"01:15:00"]
[{"$nulls":3},{"$f":"IF(C7=\"no\",D7&\", \",\"\")","v":"Monday, "},{"$nulls":5},{"$f":"IF(AND(E7=E8,F7=F8,H7=H8,I7=I8,C7=\"yes\",C8=\"yes\"),\"Monday, \"&J84,I83)","v":"Monday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."},{"$nulls":5},"01:30:00"]
[{"$nulls":3},"Tuesday, ",{"$nulls":5},{"$f":"IF(AND(E8=E9,F8=F9,H8=H9,I8=I9,C8=\"yes\",C9=\"yes\"),\"Tuesday, \"&J85,I84)","v":"Tuesday  works from 12:00 AM until 12:00 AM and  works from 12:00 AM until 12:00 AM, coverage needed from 12:00 AM until 12:00 AM which is 0.00 hours."},{"$nulls":5},"01:45:00"]
[{"$nulls":3},"Wednesday, ",{"$nulls":11},"02:00:00",{"$nulls":8},{"$f":"IF(C7=$Z$120,Z91,\"0\")","v":"0"},"yes",{"$f":"(X91-INT(X91))*24","v":0},0,{"$f":"AB120-AA120","v":0},{"$f":"IF(AC120>0,AC120,0)","v":0}]
[{"$nulls":3},"Thursday, ",{"$nulls":11},"02:15:00",{"$nulls":8},"0","no",0,0,{"$f":"AB121-AA121","v":0},0]
[{"$nulls":3},"Friday, ",{"$nulls":11},"02:30:00",{"$nulls":8},"0",null,0,0,0,0]
[{"$nulls":3},"Saturday, ",{"$nulls":11},"02:45:00",{"$nulls":8},"0",null,0,0,0,0]
[{"$nulls":3},"Sunday, ",{"$nulls":11},"03:00:00",{"$nulls":8},"0",null,0,0,0,0]
[{"$nulls":15},"03:15:00",{"$nulls":8},"0",null,0,0,0,0]
[{"$nulls":15},"03:30:00",{"$nulls":8},"0",null,0,0,0,0]
[{"$nulls":15},"03:45:00",{"$nulls":8},{"$f":"IF(C14=$Z$120,Z98,\"\")","v":""}]
[{"$nulls":3},{"$f":"\"at least one parent doesn't work on \"&CONCATENATE(D118,D119,D120,D121,D122,D123,D124)","v":"at least one parent doesn't work on Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, "},{"$nulls":11},"04:00:00",{"$nulls":13},{"$f":"SUM(AD120:AD126)","v":0}]
[{"$nulls":15},"04:15:00"]
[{"$nulls":15},"04:30:00"]
[{"$nulls":3},{"$f":"LEFT(D128,LEN(D128)-2)&\".\"","v":"at least one parent doesn't work on Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday."},{"$nulls":11},"04:45:00"]
[{"$nulls":15},"05:00:00"]
[{"$nulls":3},{"$f":"IF(OR(COUNTIF(C7:C13,\"yes\")>0),D131,IF(OR(COUNTIF(C7:C13,\"no\")>0),\"No daycare is needed\",\"There are no days that daycare is not needed.\"))","v":"No daycare is needed"},{"$nulls":11},"05:15:00"]
[{"$nulls":3},{"$f":"IF(COUNTIF(C7:C13,\"yes\")>6,\"\",D133)","v":"No daycare is needed"},{"$nulls":11},"05:30:00"]
[{"$nulls":15},"05:45:00"]
[{"$nulls":15},"06:00:00"]
[{"$nulls":15},"06:15:00"]
[{"$nulls":15},"06:30:00"]
[{"$nulls":15},"06:45:00"]
[{"$nulls":15},"07:00:00"]
[{"$nulls":15},"07:15:00"]
[{"$nulls":15},"07:30:00"]
[{"$nulls":15},"07:45:00"]
[{"$nulls":15},"08:00:00"]
[{"$nulls":15},"08:15:00"]
[{"$nulls":15},"08:30:00"]
[{"$nulls":15},"08:45:00"]
[{"$nulls":15},"09:00:00"]
[{"$nulls":15},"09:15:00"]
[{"$nulls":15},"09:30:00"]
[{"$nulls":15},"09:45:00"]
[{"$nulls":15},"10:00:00"]
[{"$nulls":15},"10:15:00"]
[{"$nulls":15},"10:30:00"]
[{"$nulls":15},"10:45:00"]
[{"$nulls":15},"11:00:00"]
[{"$nulls":15},"11:15:00"]
[{"$nulls":15},"11:30:00"]
[{"$nulls":15},"11:45:00"]
[{"$nulls":15},"12:00:00"]
[{"$nulls":15},"12:15:00"]
[{"$nulls":15},"12:30:00"]
[{"$nulls":15},"12:45:00"]
[{"$nulls":15},"13:00:00"]
[{"$nulls":15},"13:15:00"]
[{"$nulls":15},"13:30:00"]
[{"$nulls":15},"13:45:00"]
[{"$nulls":15},"14:00:00"]
[{"$nulls":15},"14:15:00"]
[{"$nulls":15},"14:30:00"]
[{"$nulls":15},"14:45:00"]
[{"$nulls":15},"15:00:00"]
[{"$nulls":15},"15:15:00"]
[{"$nulls":15},"15:30:00"]
[{"$nulls":15},"15:45:00"]
[{"$nulls":15},"16:00:00"]
[{"$nulls":15},"16:15:00"]
[{"$nulls":15},"16:30:00"]
[{"$nulls":15},"16:45:00"]
[{"$nulls":15},"17:00:00"]
[{"$nulls":15},"17:15:00"]
[{"$nulls":15},"17:30:00"]
[{"$nulls":15},"17:45:00"]
[{"$nulls":15},"18:00:00"]
[{"$nulls":15},"18:15:00"]
[{"$nulls":15},"18:30:00"]
[{"$nulls":15},"18:45:00"]
[{"$nulls":15},"19:00:00"]
[{"$nulls":15},"19:15:00"]
[{"$nulls":15},"19:30:00"]
[{"$nulls":15},"19:45:00"]
[{"$nulls":15},"20:00:00"]
[{"$nulls":15},"20:15:00"]
[{"$nulls":15},"20:30:00"]
[{"$nulls":15},"20:45:00"]
[{"$nulls":15},"21:00:00"]
[{"$nulls":15},"21:15:00"]
[{"$nulls":15},"21:30:00"]
[{"$nulls":15},"21:45:00"]
[{"$nulls":15},"22:00:00"]
[{"$nulls":15},"22:15:00"]
[{"$nulls":15},"22:30:00"]
[{"$nulls":15},"22:45:00"]
[{"$nulls":15},"23:00:00"]
[{"$nulls":15},"23:15:00"]
[{"$nulls":15},"23:30:00"]
[{"$nulls":15},"23:45:00"]